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
>
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
[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,
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
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 comparin
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 Mail
6 matches
Mail list logo
