MySQL Finding data using IN and LIKE Wildcard

Question

How would I go about doing something like:

SELECT * FROM mytable
WHERE people IN ('Jack', '%Bob%')

Finding all fields that either equal 'Jack' or contain 'Bob'? I don't think my example is the proper syntax because it's not pulling up any records.

possible duplicate of [SQL Server using wildcard within IN](http://stackoverflow.com/questions/1076097/sql-server-using-wildcard-within-in) — McGarnagle, May 05 '12 at 20:45

score 4 · Accepted Answer · answered May 05 '12 at 20:44

4

Simply :

SELECT * FROM mytable WHERE people='Jack' OR PEOPLE LIKE '%Bob%'

answered May 05 '12 at 20:44

Denys Séguret

1 Answers1