Using wildcards in a SELECT query in mysql

[Doberspand]

Hi, im having some problems comparing values from a mysql database. I need to look in the database for places where my name collum contain the value word but not only word but all strings containg word. Am I able to use wildcards and then select like this:

mysql_query("SELECT * FROM mydb WHERE name = '*word*' ");

Thanks in advance.

[pipeten]

mysql_query("SELECT * FROM mydb WHERE name LIKE '%word%' ");

% being the wildcard

[sfullman]

dont forget

where field = REGEXP('word'),

regular expressions will sometimes work where wildcards won't.

Sam Fullman
Compass Point Media

http://www.mysql.com/doc/en/Regexp.html