mysql - How to SELECT multiple rows with condition that applies to multiple columns in those rows? -

mysql - How to SELECT multiple rows with condition that applies to multiple columns in those rows? -

i got table like:

users: -------------------------------------------------------------------------------- user_id: user_name: user_email: user_has_neck: user_has_eyes: user_has_head: user_has_hair 1 | john | jon@jk.com| yes | yes | | 2 | kate | kte@jk.com| yes | yes | | 3 | mark | mrk@jk.com| yes | | | 4 | kora | | yes | yes | yes | 5 | acts | act@jk.com| | | | 6 | jerw | | yes | yes | yes | too_much 7 | dude | | | | yes | too_much 8 | ninja | nja@kl.com| yes | yes | yes | too_much

now, need query like:

select * users <no_column_is_equal_to_sometimes>;

a column might have info like; 'yes','some' not 'sometimes';

how can done?... suggestion highly appreciated.

i tried,

select * users *#@!$%^()**#$ no idea..... '--------->stackoverflow'

thank you!

just explicit comparisons in where clause. here example:

select * users 'sometimes' not in (user_has_neck, user_has_eyes, user_has_head, user_has_hair);

edit:

in example, generate list query such as:

select group_concat(column_name separator ', ') information_schema.columns c table_name = 'users' , table_schema = ???;

mysql table select where rows