which one's quicker? LIKE or REGEXP..

[udendra]

I'm thinking of using a MySQL query that looks like this, on a hefty table :

mysql_query("SELECT * from tracker WHERE URI LIKE '%[url]mysite.com/movies%[/url]' ");

the Table has abt 500,000 rows and grows significantly every day.

for better speed, should I use REGEXP instead of LIKE??

:rolleyes:

BTW need to say that the num of rows matching the above query should account for about 1/3 of the total number of rows in the table.

[AstroTeg]

This is just my theory, but I'd say stay with LIKE. REGEXP requires more work on the database engine since it has to look up all the regular expression rules and try matching them all to the data in your table.