SQL Using the OR & AND operators (Newbie)

Question

I am using the OR operator in the following fashion:

SELECT * FROM Customers
WHERE City = "Berlin" OR City = "London"

The above returns a results table containing some data, however what also returns data is:

SELECT * FROM Customers
Where City = "Berlin" OR "London"

I am using a questionable SQL editor currently, and want to know if this would be valid in a MySQL environment.

score 1 · Answer 1 · edited May 23 '17 at 11:58

1

You are looking for

SELECT * FROM Customers Where City IN('Berlin', 'London');

The query:

Where City='Berlin' OR 'London'

Applies the logical OR operator (||), so OR "London" is equivalent to OR 0, and Where City = 'Berlin' OR 0; will just return 'Berlin'

Minor, but you should look at using single quotes for string literals, as this is more portable between RDBMS's and use of " will depend on ANSI QUOTES.

edited May 23 '17 at 11:58

Community

answered Dec 09 '14 at 10:00

StuartLC

1

Thanks, If i'd had a better reputation around here I would have given you an up vote. – Stephen Gray Dec 09 '14 at 10:13

score 0 · Answer 2 · answered Dec 09 '14 at 09:59

0

Well, if it valid in SQL, it should be valid in MySQL to. Are you wondering if this would be valid in MYSQL

SELECT * FROM Customers Where City="Berlin" OR"London"

It should be valid in MySQL

Hope that helps. If it does not, add a comment

answered Dec 09 '14 at 09:59

mfredy

score 0 · Answer 3 · answered Dec 09 '14 at 09:59

0

this returnd the same values as your first sql-string.

But your first string is more readable for others.

answered Dec 09 '14 at 09:59

Snickbrack

score 0 · Answer 4 · answered Dec 09 '14 at 10:00

0

You can use IN

SELECT * 
FROM Customers
Where City IN ("Berlin","London")

answered Dec 09 '14 at 10:00

Milen

score 0 · Accepted Answer · answered Dec 09 '14 at 10:06

Well, Cassini i have check your syntax and run this query on my table i did not getting same result. I am getting correct output as expected.

i have run this command:

SELECT * FROM `city` where name = 'London' or 'Berlin'

and i got only london in name column. When i run this command:

SELECT * FROM `city` where name = 'London' or name = 'Berlin'

then i got both the cities in name column. so command is valid it will return only valid output which satisfy the condition.

So, i can say that command is valid but execute only that part of query which satisfy MYSQL Select syntax.

5 Answers5