How to compare comma separated values in mysql as exact match

Question

Suppose I have table name called group and in which because of some reason I've comma separated values in field X now I want to compare an array with that field in mysql if array matches exact same then result should return.

For example : I've a row

1 - a,b,c 2 - x,y,z

so if array contains :

array(b,a,c) // Return row 1 
array(z,x,y) // Return row 2 
array(a,b) // Return false

Fix the data so every query isn't nonsense – Drew Jul 06 '15 at 04:43 — Drew, Jul 06 '15 at 04:43

Luceos · Answer 1 · 2015-07-08T17:37:32.830

-2

You might use the FIND_IN_SET function. Something like the following would work for your case on requiring b,a,c:

select * from table where FIND_IN_SET("b", `column`) AND FIND_IN_SET("c", `column`) AND FIND_IN_SET("c", `column`);

Please see the fiddle

edited Jul 08 '15 at 17:37

answered Jul 06 '15 at 04:30

Luceos

6,629
1
35
65

what if all a b and c are in row but there's an d also then also this query works but it should not – Mohit Bumb Jul 06 '15 at 05:00
`In` will check whether a value exists in the specified comma-delimited resultset – Luceos Jul 06 '15 at 05:36
Because ... ? And please do not downvote without explanation or if you think it's wrong write your own answer. The `in` operator should work with a comma delimited column. – Luceos Jul 06 '15 at 08:03
added a fiddle and used find-in-set – Luceos Jul 08 '15 at 17:37
@MohitBumb did you find a solution? Would like to know whether you did. – Luceos Jul 14 '15 at 13:06
http://stackoverflow.com/questions/31316366/mysql-returns-exact-word-match-from-text-content – Mohit Bumb Jul 15 '15 at 09:44

How to compare comma separated values in mysql as exact match

1 Answers1