Query - LIKE {3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}

[MattyO_83]

thanks Brandin,
It works great, by calling the built-in UserSpice function

Code:

$db->query()

with bounded parameters.

I could either concatinate the string var with {3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}

Code:

$item = '{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}'.$item.'{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}';

or add ' directly to the string

Code:

$item = '{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}car{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d}';

I removed the single quotes (') from LIKE

Code:

$db->query("SELECT * FROM table WHERE column LIKE ?",array($item))