1 - apat 2 - vio,apat,pat 3 - pat 4 - vio,apat 5 - pat,vio 6 - pat
SELECT * FROM table WHERE column LIKE '%pat%'
Is it possible to do a regex? Could I search for '[^\w]pat[^\w]'? The [^\w] class would match any character that is not a word character; which would include commas, as well as start and end positions.