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.

Denys Séguret · Accepted Answer · 2012-05-05 20:44:43Z

4

Simply :

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

answered May 5, 2012 at 20:44

Denys Séguret

384k90 gold badges813 silver badges780 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1