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
f 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
> Su
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 substri
--
Regards,
Owen Franssen
Twisted Designmailto:[EMAIL PROTECTED]
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
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
-
t;
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 1:49 PM
Subject: [PHP-DB] MySQL Regular expression
> I'm not a 100% sure if this is the correct list for the following
> question, so I shall apologise beforehand if I upset any one.
>
> Now, I have a field in my da
Best, of course, normalize your DB. But this may not be an option...
HTH
Ignatius
_
- Original Message -
From: "O Franssen" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, October 09, 2003 1:49 PM
Subject: [PHP-DB] MySQL Regular expression
I'm not a 100% sure if this is the correct list for the following
question, so I shall apologise beforehand if I upset any one.
Now, I have a field in my database table in the following format:
100,30,443, etc.
Representing prices for 52(53) weeks of the year and comma delimited.
Now I need to c
