mysql语法不等于许多值 [英] mysql syntax on not equal many values
本文介绍了mysql语法不等于许多值的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！
问题描述
在以下情况下，我正在尝试获取正确的语法?
I'm trying to get the right syntax for the following case?
SELECT *
FROM wp_posts AS p
WHERE post_type = 'post'
AND post_status = 'publish'
AND ID <> 5616,1095,1357,271,2784,902
ORDER BY post_title DESC
推荐答案
您可以使用NOT IN (5616,1095...)
SELECT *
FROM wp_posts AS p
WHERE post_type = 'post'
AND post_status = 'publish'
AND ID NOT IN (5616,1095,1357,271,2784,902)
ORDER BY post_title DESC
这篇关于mysql语法不等于许多值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
查看全文
