Select value from a (SET) list
Ok I found the solution by myself, thanks to Rick James for giving me an enlightenment.

The Right MySql call for this, is

SELECT * WHERE labels LIKE 'N'


Just to mention:
labels is a SET('Y','N') column and I want to check, if a row has value 'Y' or 'N'
then get the row.

The SET column doesn't work with labels='N' because by default is labels='Y','N'