Re: MySQL: Alphabetizing title results in library format
| From: | Ian Evans | Date: | Thu, 01 Nov 2001 04:09:09 +0000 |
| Subject: | Re: MySQL: Alphabetizing title results in library format | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13898@lists.php.net to get a copy of this message | ||
Petr Tuma wrote:
select *,(case when Title like 'The %' then substring (Title, 5, 255)
ETC.Alas, MySQL doesn't like that syntax either. :( -- Ian Evans Digital Hit Entertainment - News and Information http://www.digitalhit.com