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.
Just keep adding them with OR in between:
SELECT * FROM table WHERE Name LIKE '%John%' OR Name LIKE "%mark%" OR Name LIKE "%raymond%"
Excellent. Thanks!! Obviously having a blonde moment!! Much appreciated.