Multiple conditions in one query separated by OR operator in SQL

Question

Basic question. In SQL, is there a quicker way to list conditions in a SELECT statement using the OR operator?

At the moment I'm writing multiple conditions in my statements like this:

SELECT * FROM customers WHERE City = 'Berlin' OR City = 'London' OR 
City = 'Dublin';

Is there a shorter way of doing this, without having to write 'City =' for each condition, perhaps?

Gordon Linoff · Accepted Answer · 2017-12-01 22:05:50Z

1

Use IN:

SELECT c.*
FROM customers c
WHERE c.City IN ('Berlin', 'London', 'Dublin');

In addition to being more concise, this is more efficient for long lists as well. MySQL sorts the list of values and uses a binary search for long lists -- much more efficient than a sequential search under most circumstances.

answered Dec 1, 2017 at 22:05

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

Collectives™ on Stack Overflow

Multiple conditions in one query separated by OR operator in SQL

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related