Regexp

[alirezaok]

hi

i used of phpmyadmin for serach on database and i found that REGEXP is better than of LIKE in sql of my script

so i chaged my script from

$Query = "SELECT * FROM $D1 WHERE ((REPLACE(fname, ' ', '') LIKE '%$T1%') && (REPLACE(lname, ' ', '') LIKE '%$T2%')) limit $limitvalue, $limit";

to

$Query = "SELECT * FROM $D1 WHERE ((REPLACE(fname, ' ', '') REGEXP '$T1') && (REPLACE(lname, ' ', '') REGEXP '$T2')) limit $limitvalue, $limit";

but it doesn't work in my script and i don't give any result.

any idea?