Multiple WHERE values?

Another PHP question...

I want to display specific values based on a users internalKey but I am using a WHERE clause to gather the info. The issue I have is that I want to gather more than one users info but still specify which internalKey to gather from.

Can you have a statement that is like this. WHERE internalKey = 1,2,3 I would like to specify the keys like I said within the WHERE but I’m not sure if this is possible?

Thanks.

Quote from: rossco at Mar 14, 2010, 08:43 AM

Can you have a statement that is like this. WHERE internalKey = 1,2,3 I would like to specify the keys like I said within the WHERE but I’m not sure if this is possible?

Well, its not really PHP question...

http://bytes.com/topic/mysql/answers/76582-mysql-operator-syntax

Nice! I searched Google but couldn’t find anything... as for not being PHP, I guess mysql? Anyway that looks like what I need, Thanks a lot!

You’ll get a better result without the equals sign: IN is the operator. Example from MySql manual site:
KP