FRe[2]: [PHP-DB] MySQL Regular expression

2003-10-10 Thread Rory McKinley 
 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]
 
 
 
 


-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: FRe[2]: [PHP-DB] MySQL Regular expression

2003-10-10 Thread O Franssen 
Thanks very much for your help Rory. :)

-- 
Regards,
Owen Franssen
Twisted Designmailto:[EMAIL PROTECTED]

-- 
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php