[RESOLVED] Or statements?

[netfrugal]

How does one put 'or' inside a query?

Essentially I want to say this:

SELECT * FROM table1 WHERE column1 = 'xyz' OR 'abc'

Is there a way to do this?

[Piranha]

You have to use a statement that returns TRUE or FALSE on each statement in the WHERE part of the query. You have the following statements:

1. column1 = 'xyz'
2. 'abc'

As you probably can see from this the first statement will return true or false, but not the second one. To solve the problem you need to use the whole statement there as well.

SELECT * FROM table1 WHERE column1 = 'xyz' OR column1 = 'abc'