WHERE type != 1 AND type !=2 ma li estrappola lo stasso

[GioMBG]

ciao Raga,
butto la spugna;
WHERE type != 5 AND type != 6
( ma canno da qualche parte perché tira su anche type = 5 e type 6

ecco a voi la query comleta
grazie
Gio

--

SELECT DATA.ID AS DATA_ID,
DATA.CATALOG AS DATA_CATALOG,
DATA.TRACK AS DATA_TRACK,
DATA.cn AS DATA_cn,
DATA.prod AS DATA_prod,
DATA.yy AS DATA_yy,
DATA.isrc AS DATA_isrc
FROM data_keep_calm_records.DATA JOIN data_keep_calm_records.data ON DATA.ID = data.id
WHERE type != 5 AND type != 6 AND
genre = "House" OR genre = "Tech House"
ORDER BY RAND() LIMIT 1

 

[criric]

Ciao metti le parentesi per le due condizioni OR

WHERE type != 5 AND type != 6 AND (genre = "House" OR genre = "Tech House")

puoi usare anche NOT IN e IN

WHERE type NOT IN (5,6)  AND genre IN ("House","Tech House")

sposto la discussione in database