MySQL query String contains

Question

I ve been trying to figure out how I can make a query with MySQL that checks if the value  string  haystack   in a certain column contains certain data  string  needle   like this   mysql query   SELECT   FROM  table  WHERE  column  contains    needle          In PHP  the function is called substr  haystack   needle   so maybe   WHERE substr  column      needle    1

User · Answer

Use   SELECT     FROM  table   WHERE INSTR  column      needle     gt  0   Reference    INSTR

User · Answer

In addition to the answer from  WoLpH   When using the LIKE keyword you also have the ability to limit which direction the string matches  For example   If you were looking for a string that starts with your  needle       WHERE column LIKE    needle      If you were looking for a string that ends with the  needle       WHERE column LIKE     needle

User · Answer

You probably are looking for find in set function   Where find in set  needle  column    gt  0   This function acts like in array function in PHP

User · Answer

Mine is using LOCATE in mysql      LOCATE substr str   LOCATE substr str pos    This function is multi-byte safe  and is case-sensitive only if at least one argument is a binary string   In your case   mysql query   SELECT   FROM  table  WHERE LOCATE    needle    column    gt  0

User · Answer

WHERE  column  LIKE    needle

User · Answer

be aware that this is dangerous    WHERE  column  LIKE     needle      do first    needle   mysql real escape string  needle     so it will prevent possible attacks

User · Answer

Quite simple actually   mysql query   SELECT   FROM  table  WHERE  column  LIKE     needle          The   is a wildcard for any characters set  none  one or many   Do note that this can get slow on very large datasets so if your database grows you ll need to use fulltext indices

[php] MySQL query String contains

Examples related to php

Examples related to mysql

Examples related to sql

Examples related to string-comparison