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 Design                            mailto:[EMAIL PROTECTED]

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

Reply via email to