well yes, somehow my field has like: field1 ------ 1.2 99.123 500x120 561x112 5.5 so as you see this 'field1' have both normal numeric values and sometimes 'YYYxYYY' values... I thought that MySql can somehow compare XXXX with another number YYYY and compare correctly YYYYxYYYY with anoter value just like it: ZZZZxZZZZ anyway...I just forgot about it and droped the YYYxYYY from my table and only allowed numerical input, The problem is that I'm using the same field for two type of data storage... "Brad Wright" <[EMAIL PROTECTED]> wrote in message [EMAIL PROTECTED]">news:[EMAIL PROTECTED]... > I would use something like this: > > Select * from table where value1 < 500 AND value2 < 100 > > > hope this helps, > brad > > > From: "elias" <[EMAIL PROTECTED]> > > Date: Fri, 13 Jul 2001 07:06:26 -0700 > > To: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] > > For additional commands, e-mail: [EMAIL PROTECTED] > > To contact the list administrators, e-mail: [EMAIL PROTECTED] > > > -- PHP General Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]
