retrieving digit from a string mysql

Question

I've got a mysql database containing table "numbers" and entries

id | numberss
1 | 1,5,45
2 | 11,8,99
3 | 14, 15,84
4 | 1,58,47

How I have to write a mysql query, to retreive info only from those tables, which got number "1" in field "numberss" ? Not 11, not 15, only 1. Now I have:

mysql_query("SELECT * FROM numbers WHERE numberss LIKE '%1%'");

But of course it doesn't work how I want to...

Shakti Singh · Accepted Answer · 2012-09-11 11:32:01Z

3

SELECT * FROM numbers WHERE FIND_IN_SET(1, numberss);

answered Sep 11, 2012 at 11:32

Shakti Singh

86.7k21 gold badges142 silver badges156 bronze badges

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

Comments

cadaver · Accepted Answer · 2012-09-11 11:41:46Z

0

SELECT * FROM numberss WHERE numberss 
LIKE  '%[^0-9]1[^0-9]%' 
or numberss like '1[^0-9]%'  
or numberss like '%[^0-9]1'

should work

edited Sep 11, 2012 at 11:41

answered Sep 11, 2012 at 11:33

cadaver

3652 silver badges12 bronze badges

Collectives™ on Stack Overflow

retrieving digit from a string mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related