Postgres Query with LIKE and NOT EQUAL TO

Question

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

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?

Juan Carlos Oropeza · Accepted Answer · 2017-05-30 14:39:00Z

16

You probably need parenthesis because AND has operator precedence.

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' );

answered May 16, 2016 at 18:14

48.4k14 gold badges87 silver badges128 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1