SELECT * FROM `o2o_category` WHERE `parent_id` = 0 AND `status` IN (neq,-1) ORDER BY `id` DESC

Question

SELECT * FROM `o2o_category` WHERE `parent_id` = 0 AND `status` IN (neq,-1) ORDER BY `id` DESC

求解决？？

Answer 1

在写where条件的时候 直接使用status!=-1 不就解决了 干嘛还用in 然后有不等于-1 繁琐死了