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

2003-10-09 Thread O Franssen 
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 Designmailto:[EMAIL PROTECTED]

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

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

2003-10-09 Thread O Franssen 


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

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

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

2003-10-09 Thread O Franssen 
This almost worked :p

I applied your suggestion in the following way:
select * from ihrproperties where region = 'Kerry' and 0  
substring_index(substring_index(rates, ',', 41), ',', -1)  1568

But of course my prices are saved as text so is there a way to
type cast the result of the substring_index() or something
similar?

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

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