PHP MySql Like Query to Match Int in String

Question

I am trying to do what seems to be a simple MySQL query but cannot get it to work.

$query = "SELECT * FROM $table WHERE $match_column LIKE CONCAT('%',CAST($match_value AS CHAR),'%') ; <br />

The data in $match_column is a string of integers separated by a comma like this: 1,3,13,2. The data type in the table is varchar. If my search term is any one of those integers, such as 13, I want to include that row in result but it doesn't work. The query string does work on data with a single integer in $match_column. Using regEx might be the answer, but I am nor proficient there. Any help will be appreciated.

What results are you seeing? None at all? On another note, keep in mind that you need to make sure "1" doesn't match "11,12,13"; your current code would have this issue even if it was working the way you intended. — user1618143
– user1618143, Commented Jun 10, 2013 at 21:01
You may want to look at FIND_IN_SET: dev.mysql.com/doc/refman/5.0/en/string-functions.html — keithhatfield
– keithhatfield, Commented Jun 10, 2013 at 21:18

RealAT · Accepted Answer · 2014-12-03 15:53:22Z

1

Try using FIND_IN_SET:

$query = "SELECT * FROM $table WHERE FIND_IN_SET('$match_value', $match_column);"

edited Dec 3, 2014 at 15:53

RealAT

52 bronze badges

answered Jun 10, 2013 at 21:23

keithhatfield

3,2831 gold badge20 silver badges25 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

noCodeMonkeys Over a year ago

Works like a charm. I guess I'm rustier than I thought on my MySQL! Thanks.

Collectives™ on Stack Overflow

PHP MySql Like Query to Match Int in String

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest