Re: query question

On Wednesday 15 January 2003 01:47, Kelly Meeks wrote: > I've got an array of values, that I need to query against a database to see > if any records have any of the values in the array - the array is a list of > zip codes, and the database contains a list of stores. Basically i need to > find what stores have zip codes in the array. > > I know that mysql doesn't support subquerys - is there a workaround for > this kind of scenario? This is more of a mysql question and should be asked on the php-db list if not the mysql list. What you need is something like: "SELECT doo FROM dah WHERE dee IN('val1', 'val2', ..., 'valN'" -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* PEGGY FLEMMING is stealing BASKET BALLS to feed the babies in VERMONT. */