very long where part in sql query help

foe

I have a mysql query which will look like select * from table_name where id='222' or id = '213' or id = '21' or id = '653'

there will be more than 1000 such or statments.

these numbes are not in order and are pretty much random, anyway to make this faster?

Thanks in advanced

thorpe

are they in any range or anything? i dont really understand why you would need to do this sort of thing.

leatherback

Perhaps try:
[edit]
this is in case you really cannot get the data from the database in a more elegant way then 1000+ or statements, which I highly doubt. So please elaborate a bit.. [/edit]
create an array ($wanted) with
id => true

select * from table

-- during data-retrieval:

if($wanted[$roiw[id]])
{

// do your thing

}

else
{}

foe

This is the case because I am using an abstraction class which returns a list of ids. These Ids have weird patterns to them. I could build the where cause on the fly, but is there a performance hit in having a really long sql query?

Basically it works now, but just want to make it faster.

foe

Nobody?

Drakla

You could create a comma separated list of the ids, with implode if they're in an array then make your query use the IN caluse

$allIDs = implode(',', $ids);

$q = "SELECT * FROM table WHERE id IN ($allIDs)";

Don't worry about the size of the query string, it can be about 16 Meg or something in a standard install (I think).