M Argus Chopin Gyver M Argus Chopin Gyver - 3 years ago 55
MySQL Question

MySQL search per char

I have a table, look like this
enter image description here

and I want to query the table for looking that

GROUP_CONCAT(product_id SEPARATOR ', ')
field have
7
and
10
.

Like
statement is not working well for me because it's only showing the first row and not showing the third row, even it has
7
and
10
but separated with
8
between it..

enter image description here

Is there's any
WHERE STATEMENT
that I can use for this ?

Answer Source

Why should be troubled ?

Try this

SELECT * from table where field REGEXP 'abdan|copin|sher'; 
Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download