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.