MySQL check if field has number in it

Question

I'm looking to do a simple comparison test in MySQL, I have a field that stores ID's like so:

1;2;23;12

Or if only one option was selected when creating that entry it would only be one:

At any rate I am looking to filter my select query to find entries in the DB that have for instance the ID 2 in them. So I need some sort of comparison to compare that id 2 against that column with those values and a possible single value.

dani herrera · Accepted Answer · 2012-08-09 19:03:06Z

3

You are looking for find_in_set function:

Select 
   *
from 
   your_table
where 
   FIND_IN_SET('2',REPLACE( '1;2;23;12', ';' , ',' ) ) > 0

I would recommend to you to normalize database (see: http://en.wikipedia.org/wiki/First_normal_form) Also, notice to you that this kind of queries don't has high performance.

answered Aug 9, 2012 at 19:03

dani herrera

52k11 gold badges133 silver badges188 bronze badges

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

1 Comment

jfreak53 Over a year ago

Awesome! Yeah I'm not really worried about speed with this, since there really aren't going to be many in there record wise, it saves me from having to do a new form for adding and a second table for xreference.

Collectives™ on Stack Overflow

MySQL check if field has number in it

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

Related