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 [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

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

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 with another number and compare correctly x with anoter

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

PROTECTED] Date: Wed, 25 Jul 2001 10:22:32 +0200 To: [EMAIL PROTECTED] Subject: Re: [PHP] MySql number/string comparing ideas... 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

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

10:22:32 +0200 To: [EMAIL PROTECTED] Subject: Re: [PHP] MySql number/string comparing ideas... 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' value