MySQL select using wildcard (but wildcard in field)

Question

I have a mysql 5 table with a char field holding

DOG
DOUG
CAT
MOUSE

Now I want to SELECT on this field, finding any rows where that field exist within a string, like "DOGGY". (This is opposite of how you normally use a wildcard). So I want a select something like: SELECT FROM TABLE WHERE FIELD IS SUBSTRING OF "DOGGY"

Is this possible?

Answer 1

select * from mytable where 'doggy' like concat('%',mycol,'%')

Answer 2

You should be able to use LOCATE() to achieve this:

SELECT * FROM MyTable WHERE LOCATE(MyField, 'DOGGY') != 0;