CODEWITHSUNDEEP
postgresqlwhere-clause
Dashiell0415
Dashiell0415

Reputation: 79

postgres syntax question for OR?

The first one below works, but, just wanted to see if there's a better way...

If I'm trying to find all records that start with 'C' with either a flag of 2 or a status of 9, do I need to incorporate the 'C' criteria twice?

i.e., 

"SELECT * FROM mytable WHERE name like 'C%' AND flag = 2 OR name like 'C%' AND status = 9"

Or, is there a way quicker way to write it so that I only need to set 'C%' once?

Upvotes: 0

Views: 75

Answers (2)

Peter Tillemans
Peter Tillemans

Reputation: 35331

OR has lower priority than AND so you need parentheses.

WHERE name LIKE "C%" AND (flag = 2 OR flag = 9)

you can also check for membership of a set of values

... AND flag IN (1, 9)

Upvotes: 1

kennytm
kennytm

Reputation: 523264

Logically, AND and OR are distributive to each other, i.e.

a & (b | c) = (a & b) | (a & c)

that means your condition can be rewritten as

name LIKE 'C%' AND (flag = 2 OR status = 9)

Upvotes: 1

Related Questions