Multiple values in MySQL where statement?

[demiancurran]

Hey there, I am trying to populate a loop using the following.

<cfquery name="notice" datasource="#DSN_DATASOURCE#" username="#DSN_USERNAME#" password="#DSN_PASSWORD#">
Select    *
From	  notice
Where 	id = "1,5,7"
</cfquery>

The problem is the 1,5,7 obviously. This info is coming through the url.id and I need to be able to loop through 1,5,7. Is there a way to do this?

Thanks

 

[lgarner]

Try "where id in (1,5,7)".