Mysql question: Searching through the second string of a value.

[makoy]

Hello phpbuilders!I would like to ask if there's a way to search the second string of a column in mysql? For example, I have a name column and it has a a value "Super Man". How can I search the second string which is the man so that it will display all the values with a man on it. Thank you in advance.

[tomhath]

You could do it with wildcards:

select * from MyTable where MyColumn like "%man%"

But the best way would be to use a regular expresson: http://dev.mysql.com/doc/refman/5.0/en/regexp.html

[makoy]

Perfect! Thank you very much sir!