SELECT * FROM 'mytable' WHERE INSTR('mycol', 'abc') > 0
The above example return all rows in table “mytable” where the column “mycol” contains the string “abc”.
4 thoughts on “Check if string or character exists in MySQL database row”
Leave a Reply
Markdown is allowed in comments.
Thank you.. Helped me..
Thank you a lot. It was exactly was I was looking for.
thanks very useful
The mentioned command is case-sensitive.
If you need it case-insensitive this one should work:
SELECT * FROM `mytable` WHERE `mycol` LIKE ‘%abc%’;