> -----Original Message----- > From: Mikey [mailto:[EMAIL PROTECTED] > Sent: Friday, May 30, 2003 11:53 AM > To: [EMAIL PROTECTED] > Subject: Why doesn't this query work? > > > OK, first of all thanks for the pointers, however, the query I now have > doesn't seem to work. If I run the query up until "pricelevel IN > (1, 2, 3, > 4, 5)" it returns a large result set (the clauses are fairly inclusive), > however, when I add in the rest of the query no results are returned. Any > ideas?
This is just a guess, but perhaps you are comparing INTs to STRINGs with that last bit, in which case you'd want to change the column type for pricelevel or put quotes around the numbers in the query? I hit that problem all the time using 1 and 0 as Booleans in an ENUM column. Nick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]