Useful Snippets

Welcome!


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

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”.

Source

INSTR on MySQL.com

Web Developer at Aftonbladet (Schibsted Media Group)
Any opinions on this blog are my own and do not reflect the views of my employer.
LinkedIn
Twitter
WordPress.org 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%’;