Useful Snippets


This blog is used to collect useful snippets related to Linux, PHP, MySQL and more. Feel free to post comments with improvements or questions!

Are your smart devices spying on you? Make better purchasing choices and find products that respect your privacy at

RSS Latest posts from my personal blog

Most viewed posts

Subscribe to RSS feed

Check if string or character exists in MySQL database row

Stanislav KhromovStanislav Khromov
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”.



Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
Twitter Profile
Visit my other blog

Comments 4
  • Rahul
    Posted on

    Rahul Rahul

    Reply Author

    Thank you.. Helped me..

  • Diana M
    Posted on

    Diana M Diana M

    Reply Author

    Thank you a lot. It was exactly was I was looking for.

  • corsi
    Posted on

    corsi corsi

    Reply Author

    thanks very useful

  • Matthias Radde
    Posted on

    Matthias Radde Matthias Radde

    Reply Author

    The mentioned command is case-sensitive.
    If you need it case-insensitive this one should work:
    SELECT * FROM `mytable` WHERE `mycol` LIKE ‘%abc%’;