Re: Re: Strange Query Error...
| From: | Karl DeSaulniers | Date: | Sun, 28 Nov 2010 06:13:52 +0000 |
| Subject: | Re: Re: Strange Query Error... | ||
| References: | 1 2 3 4 5 | Groups: | php.db php.general |
| Request: | Send a blank email to php-db+get-47511@lists.php.net to get a copy of this message | ||
On Nov 27, 2010, at 1:24 PM, Don Wieland wrote:
On Nov 27, 2010, at 10:44 AM, Daniel P. Brown wrote:Don't know if you necessarily need this but I found it while checking to see if one letter names are a good idea in MySQL statements. Might help in your like query. http://techonthenet.com/sql/like.php HTH, Best, Karl DeSaulniers Design Drumm http://designdrumm.comNote how you keep changing case here. For example, m.aucciim_id vs. m.AUCCIIM_ID. Also note that all of this is cAsE-sEnSiTiVe.You are right. But it still chokes in PHP: select m.* from Members m inner join Member_Years my on m.AUCCIIM_ID = my.member_id where now() < DATE_ADD(DATE_SUB(concat(member_year + 1,'-07-01'), INTERVAL 1 DAY), INTERVAL 30 DAY) AND m.Preferred_First_Name LIKE 'Don%' group by m.AUCCIIM_ID order by m.preferred_last_name Don