postgresql 带有 LIKE 和 NOT EQUAL TO 的 Postgres 查询

Postgres Query with LIKE and NOT EQUAL TO

提问by nateM

I'm trying to write a query with LIKE and != conditions:

我正在尝试使用 LIKE 和 != 条件编写查询：

SELECT * 
FROM   posts 
WHERE  title LIKE 'term%' 
  OR   NAME LIKE 'term%' 
 AND   post_type != 'type'; 

However, the query results are not being filtered by post_type. Is there something wrong with my syntax?

但是，查询结果没有被 post_type 过滤。我的语法有问题吗？

回答by Juan Carlos Oropeza

You probably need parenthesis because ANDhas operator precedence.

您可能需要括号，因为AND具有运算符优先级。

SELECT * 
FROM   posts 
WHERE  ( title LIKE 'term%' OR NAME LIKE 'term%' )
  AND    post_type != 'type';

Because right now without parenthesis you have

因为现在没有括号，你有

SELECT * 
FROM   posts 
WHERE  title LIKE 'term%' 
  OR   (       NAME LIKE 'term%' 
         AND   post_type != 'type' );