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]
