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

2001-07-25 Thread elias
t; From: "elias" <[EMAIL 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 >

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

2001-07-25 Thread Brad Wright
ot;elias" <[EMAIL 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 > 561x1

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

2001-07-24 Thread elias
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 value

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

2001-07-24 Thread Lawrence . Sheed
start.. -Original Message- From: Brad Wright [mailto:[EMAIL PROTECTED]] 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 hop

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

2001-07-24 Thread Brad Wright
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 pos