MySQL Where IN

[rawrzz]

Thanks for reading

 

Here is my problem:

 

$idstr = "'a','a','a'";

SELECT * FROM tablename WHERE id IN ($idstr)

 

and using a while loop for each result (row)

 

However, it only fetches the row where the id is 'a' once.

Is there anything i can do to make it return the same row 3 times while still being able to use the WHILE loop?

 

Thanks again in advance

[fenway]

MySQL will return the rows that match ANY of those values.  Why do you want it 3 times?

[rawrzz]

Each time a row is returned, the information from the row is declared to an array.

 

So basically, this is what i am trying to achieve:

 

Query for a,b,c,d where the ID is equivalent to a,b,c,d

this would result in giving me 4 rows of data, which is perfect

 

however

 

When querying for a,a,a,c, is there a way to fetch the rows so it returns 4 rows?

 

Thanks for the response

[jdavidbakr]

So you want the same row ('a') returned three times and then the 4th row ('c') returned once?  No, you can't do that, unless you are joining it against another table.  What are you trying to accomplish?

[rawrzz]

Ah I see, I was hoping there was an alternate clause similar to IN that would allow me to do what Jon described.

 

I will revise my scripting around this then.

 

Thanks!