On Sat, Nov 13, 2004 at 12:46:12PM -0800, Stuart Felenstein wrote: > > --- Jim Winstead <[EMAIL PROTECTED]> wrote: > > > You can't compare a column with a comma-delimited > > list of numbers like > > that....... > > What should the seperator be then ?
My point was that you can't compare a column with an array of numbers using the '=' operator. You have to use the IN operator, as in the line of code I posted: $sql .= " WHERE VendorJobs.Industry IN ($s_Ind)"; (where $s_Ind is a comma-delimited list of numbers or quoted strings.) -- Jim Winstead MySQL Inc. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]