mysql queries

[JeremysFilms]

if i want to delete all rows where the value is equal to a bunch of things, would i be able to do something like:
DELETE FROM tbl WHERE bob='hi' OR 'hello' OR 'hey'
is there any way to do something like that? or do i need to do a query for each?

[Foxtrott]

You could do:
DELETE * FROM TABLE WHERE `thing`='something' AND `bla`='454'
and etc. You can use as many "AND" as you want.

[DFox]

I think it would need to look like:

DELETE FROM tbl WHERE bob='hi' OR bob='hello' OR bob='hey'

If you have too many and don't feel like doing that, just throw them in an array and have a loop tack them on to the SQL statement.

[henke37]

There is a shorter form:
where a in ('a','b','c')

Much less typing

[Rellizate]

DELETE FROM `bob` WHERE `1` = '1' | `2` = '2';

[Zendra]

At 11/14/06 10:50 AM, Rellizate wrote:

'1' | `2`

Something is wrong with that part.

[Storm]

At 11/14/06 10:50 AM, Rellizate wrote: DELETE FROM `bob` WHERE `1` = '1' | `2` = '2';

Isn't OR supposed to be || ?

[Rellizate]

My mistake:

DELETE FROM `bob` WHERE `1` = '1' || `2` = '2';