REGEXP vs LIKE/OR

[Morten Primdahl]

Hi,
I want to retrieve all records where the field "value" contains either  
"foo", "bar" or "baz". Like so:

SELECT id FROM table WHERE value LIKE '%foo%' OR value LIKE '%bar%' OR  
value LIKE '%baz%';

But then I stumbled upon REGEXP, and can do the same this way:

SELECT id FROM table WHERE value REGEXP 'foo|bar|baz' != 0;

Any opinions on what's the better approach and why?

Thanks

Morten





--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]