PHP MYSQL LIKE query with several items

PHP
1

Can anyone tell me how I would set up a query so that it will select rows based on where a column contains any one of 5 values. For example if name field contains john or mark or raymond. Sounds like it should be straight forward but I can’t think how I would code that. What I use for a single option would be this:

SELECT * FROM table WHERE Name LIKE ‘%John%’

Thanks for any help in advance with this.

2

Just keep adding them with OR in between:

SELECT * FROM table WHERE Name LIKE ‘%John%’ OR Name LIKE “%mark%” OR Name LIKE “%raymond%”

etc :slight_smile:

3

Excellent. Thanks!! Obviously having a blonde moment!! Much appreciated.