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