Re: MySQL: Alphabetizing title results in library format
| From: | Ian Evans | Date: | Thu, 01 Nov 2001 09:19:46 +0000 |
| Subject: | Re: MySQL: Alphabetizing title results in library format | ||
| References: | 1 2 3 4 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13903@lists.php.net to get a copy of this message | ||
Petr Tuma wrote:
What error message it produce?Ok, table titles is composed of: +----------+-------------+----------------+
| titlesid | releaseyear | title |+----------+-------------+----------------+ mysql> select *,(case when title like 'The %' then substring (title, 5, 255) when title like 'A %' then substring (title, 3, 255) when title like 'An %' then substring (title, 4, 255) else title end) as sort_col from titles order by sort_col; ERROR 1064: You have an error in your SQL syntax near 'when title like 'The %' then substring (title, 5, 255) when title like 'A %' the' at line 1 -- Ian Evans Digital Hit Entertainment - News and Information http://www.digitalhit.com