Combining AND & OR in MySQL Queries

Combining AND & OR in MySQL Queries

10-03-2008, 08:52 AM

[eluser]gRoberts[/eluser]
You could use the "in" method.

i.e.

Code:
SELECT * FROM Persons WHERE

LastName='Svendson'

AND FirstName in ('Tove','Ola')

Messages In This Thread

Combining AND & OR in MySQL Queries - by El Forum - 10-03-2008, 07:58 AM

Combining AND & OR in MySQL Queries - by El Forum - 10-03-2008, 08:41 AM

Combining AND & OR in MySQL Queries - by El Forum - 10-03-2008, 08:52 AM

Combining AND & OR in MySQL Queries - by El Forum - 10-03-2008, 10:43 AM