Why does not this query return results?

Navigation
0

I have this query to mysql: 

SELECT * FROM 'Articulos' WHERE FIND_IN_SET('color', '310') AND FIND_IN_SET('talla', '305') AND FIND_IN_SET('empresa', '199')

and here is a screenshot of php myadmin from the list of articles where you can see if that combination exists.

What do I have wrong for me to return 0 if there are results?

    
asked by Killpe 09.12.2017 в 17:38
source

1 answer

2

The syntax is FIND_IN_SET (search string, string list) 

SELECT * FROM Articulos 
    WHERE FIND_IN_SET('310', color) > 0 AND 
          FIND_IN_SET('305', talla) > 0 ;
    
answered by 09.12.2017 / 18:12
source
Clear variables in url in the best way! Align image to text with css