RE: [PHP] MySql number/string comparing ideas...

jumping in after the fact here, but sounds like a bad database design to me have you thought about redoing the data a little. eg adding a column x int, y int , iterating through the data, and extracting the values into those columns. using explode to split the original via the x would be a start.. -----Original Message----- From: Brad Wright [mailto:bradwright@optushome.com.au] Sent: July 25, 2001 2:33 PM To: elias; PHP General List Subject: Re: [PHP] MySql number/string comparing ideas... I would use something like this: Select * from table where value1 < 500 AND value2 < 100 hope this helps, brad > From: "elias" <elias_bachaalany@yahoo.com> > Date: Fri, 13 Jul 2001 07:06:26 -0700 > To: php-general@lists.php.net > Subject: [PHP] MySql number/string comparing ideas... > > Hi! > > How is it possible to do a MySql query for something like: > > SELECT value from table WHERE value < '500x100' > > should return all values that part1 must be less than 500 and part2 less > than 100? like 499x99 and reject something like: 500x101 > > please give me suggestions! > > > > > > -- > PHP General Mailing List (http://www.php.net/) > To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net > For additional commands, e-mail: php-general-help@lists.php.net > To contact the list administrators, e-mail: php-list-admin@lists.php.net > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: php-general-unsubscribe@lists.php.net For additional commands, e-mail: php-general-help@lists.php.net To contact the list administrators, e-mail: php-list-admin@lists.php.net