Apologies for any confusion - wrong list. Should have gone to PHP-DB
instead.....TGIF.
----- Original Message -----
From: "Rory McKinley" <[EMAIL PROTECTED]>
To: "O Franssen" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Friday, October 10, 2003 9:14 AM
Subject: Re: Re[2]: [PHP-DB] MySQL Regular expression
> HI Owen
>
> I am not sure about strcmp - I have never used it on numbers before..MySQL
> 2nd Ed by DuBois <PLUG> Which is well worth the money - makes me look
> intelligent </PLUG> says that strcmp sorts lexically...and to be quite
> honest, I need to go look that up...... but I think it will work...
>
> However, using the code from your previous comment, you can try casting
your
> result as an unsigned integer like so (if yourMySQL is ver 4.0.2 or up)...
>
> select * from ihrproperties where region = 'Kerry' and 0 <
> CAST(substring_index(substring_index(rates, ',', 41), ',', -1) AS UNSIGNED
> INTEGER) < 1568
>
> If you don't have 4.0.2 - I would suggest you try strcmp and see ...
>
> Rory McKinley
> Nebula Solutions
> +27 82 857 2391
> [EMAIL PROTECTED]
> "There are 10 kinds of people in this world,
> those who understand binary and those who don't" (Unknown)
> ----- Original Message -----
> From: "O Franssen" <[EMAIL PROTECTED]>
> To: "Rory McKinley" <[EMAIL PROTECTED]>
> Sent: Thursday, October 09, 2003 6:22 PM
> Subject: Re[2]: [PHP-DB] MySQL Regular expression
>
>
> > Actually in response to my previous comment, would the following
> > achieve wwhat I want?
> >
> > ... and strcmp('$foot_budget', substring_index(substring_index(rates,
',',
> $selecteddate), ',', -1)) = -1 and strcmp('$head_budget',
> substring_index(substring_index(rates, ',', $selecteddate), ',', -1)) = 1
> >
> > --
> > Regards,
> > Owen Franssen
> > Twisted Design
mailto:[EMAIL PROTECTED]
> >
> >
> >
> >
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
>
>
>
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
