comprae value in JSON_TYPE in mysql

Question

I have a field in my Database table colled interet, it has a json array like you see in this picture.

I want to check if one values or two is IN this fields using Mysql query. I was trying to do this query:

SELECT * FROM customers c WHERE c.interet IN ('Voyage','Technologie','Mode')

But I got nothing

What you have in your table is not JSON but simply comma separated values in a column. Which you should not be saving in a column. Please see http://stackoverflow.com/a/41215681/267540 and http://stackoverflow.com/a/41305027/267540 — e4c5, Jan 03 '17 at 12:07
not json array but can use like : where c.interet like '%Voyage%' or c.interet like '%Technologie%' or c.interet like '%Mode%' group by id — san san, Jan 03 '17 at 12:10
JSON will only make things marginally better. Please google for database normalization and read the two QAs in my previous comment — e4c5, Jan 03 '17 at 12:20

score 1 · Accepted Answer · answered Jan 03 '17 at 12:08

1

Since it is not json USE like operator

    SELECT * FROM customers c WHERE 
    c.interet LIKE '% Voyage %' OR 
    c.interet LIKE '% Technologie %' OR 
    c.interet LIKE '% Mode %'

answered Jan 03 '17 at 12:08

Sanooj T

1

yes this works and if you have a few hundred thousand rows, make your service unresponsive – e4c5 Jan 03 '17 at 12:13
Ya I agree with that – Sanooj T Jan 03 '17 at 12:24

score 0 · Answer 2 · answered Jan 03 '17 at 12:10

0

The format above is not json it is a varchar. update your question and post your full sql query

answered Jan 03 '17 at 12:10

Afaf

2 Answers2