Hi guys,

I've a query built in this way

$query = "SELECT * FROM foo WHERE bar REGEXP '$item' ORDER BY data DESC
LIMIT 0,100";
$result = mysql_query($query);

It works correctly only if $item is not equal to a value in the DB.
E.G. I've column with the string patrol
If $item is different from patrol which means atrol trol atr and so on,
the query returns all the occurences of patrol.
If $item is patrol no occurrence is found.
I've tried with LIKE, with '%$item%' but without any success.

Any idea?


--
Esti Qatzi
http://zelohim.it upd 20.01.07 ubuntu user #4898

Il Fattucchiero può allacciarsi le scarpe con i piedi.