MySQL: Alphabetizing title results in library format
| From: | Ian Evans | Date: | Wed, 31 Oct 2001 22:42:43 +0000 |
| Subject: | MySQL: Alphabetizing title results in library format | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-13896@lists.php.net to get a copy of this message | ||
Back when I was working with MSSQL I need to alphabetize movie titles in the proper library format where 'A' 'An" and 'The" are ignored.
For MSSQL I was told to use:
select *
from Titles
order by 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
That worked like a charm, yet MySQL doesn't seem to accept that. Any solutions or advice?
--
Ian Evans
Digital Hit Entertainment - News and Information
http://www.digitalhit.com