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!

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

RSS Latest posts from my personal blog

Subscribe to RSS feed

RSS RSS feed

Copyright © Useful Snippets. 2024 • All rights reserved.

Cedar WordPress Theme by EckoThemes. Published with WordPress.

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

Related posts

  1. MySQL general usage snippets – connecting, listing, creating and deleting databases
  2. MySQL database that maps swedish cities to counties
  3. Dump and import a single MySQL database via command line
  4. Check and repair all databases and all tables with MySQL
MySQL
Stanislav Khromov
Author

Full-stack impostor syndrome sufferer & Software Engineer at Schibsted Media Group

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%’;