mySQL - FIND_IN_SET() doesn't find the value

Question

I m trying to get posts which includes a spesific tag.

The tag row content

,iphone|1468338028,,android|1468338028,,blackberry|1468338028,

query

SELECT * FROM shares WHERE FIND_IN_SET(tag, 'iphone') > 0 ORDER BY DATE DESC limit 10

What is the correct way to do it ?

Your tag is `iphone|1468338028` and you look for `iphone`. That does not match — juergen d, Oct 01 '16 at 17:05
[Junction Tables](http://stackoverflow.com/a/32620163) when the answer isn't unfortunately no anymore. Who knows, you might even get to use indexes — Drew, Oct 01 '16 at 17:06
The MySQL `FIND_IN_SET` function operates according to the specification laid out in the MySQL Reference Manual. And since the value 'iphone' does not appear in the set, the return is what we expect. — spencer7593, Oct 01 '16 at 17:07

score 1 · Accepted Answer · answered Oct 01 '16 at 17:06

1

Your tag is iphone|1468338028 and you look for iphone. That does not match.
Replace the | with , to separate the values.

SELECT * FROM shares 
WHERE FIND_IN_SET(replace(tag, '|', ','), 'iphone') > 0

answered Oct 01 '16 at 17:06

juergen d

Thanks, thats what I was thinking. One question, if there is an empty space, does it make problems ? – caner taşdemir Oct 01 '16 at 17:07
I'd say yes, that is a problem. Try to avoid that. – juergen d Oct 01 '16 at 17:07
Can't I use trim() in your query ? – caner taşdemir Oct 01 '16 at 17:08
1

Depends on where the space is exactly. Just try it. – juergen d Oct 01 '16 at 17:10

score 1 · Answer 2 · answered Oct 01 '16 at 17:15

1

Another alternative is to use LIKE "%text%", if you're not required to use FIND_IN_SET().

SELECT * FROM shares 
WHERE tag LIKE "%iphone%"
ORDER BY DATE DESC limit 10

Above snippet should achieve the same, thus avoiding replacing and trimming issues.

answered Oct 01 '16 at 17:15

Tool

2 Answers2