found integer in text data with mysql

Question

I have a database table,in one Column I have data Like:

id      tags
1       1.2,2.2,22.2
2       20.1,30.1,45.2,46.0,55.3 
3       1.3,6.1,7.2,9.4,10.2

I want to search ids having num 1 in tag's Column

Saharsh Shah · Accepted Answer · 2014-01-18 05:32:04Z

2

Use LIKE operator to search the data

SELECT id 
FROM tableA 
WHERE tags LIKE '%1%'

answered Jan 18, 2014 at 5:32

Saharsh Shah

29.1k9 gold badges53 silver badges85 bronze badges

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

Comments

Maheswaran Ravisankar · Accepted Answer · 2014-01-18 05:52:57Z

1

Just another using INSTR when wildcard is on both sides in a LIKE search!

SELECT id
FROM tableA
WHERE INSTR(tags,'1') > 0 ;

answered Jan 18, 2014 at 5:52

17.9k6 gold badges50 silver badges69 bronze badges

Why INSTR? Which Best INSTR or LIKE

in your case both are same! when you expect the letter to be in x location, INSTR wins. LIKE wins, when the wildcard is given only at end.