Make a distinct select in SQL,selecting all "categoria" except one distincted

Question

enter image description here

i want to select "categoria",idjogo where idjogo=NULL, except the hentai. the hentai i want to select is the one where idjogo=100;

score 0 · Accepted Answer · answered Dec 13 '19 at 11:17

0

WHERE idjogo <=> IF(categoria='hentai',100,NULL)

answered Dec 13 '19 at 11:17

ysth

1 Answers1