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

From: Date: Thu, 09 Oct 2003 16:23:50 +0000
Subject: Re[2]: [PHP-DB] MySQL Regular expression
Groups: php.db 
Request: Send a blank email to php-db+get-30934@lists.php.net to get a copy of this message
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:twisteddesign@eircom.net

« previous php.db (#30934) next »