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)
Message-
From: Ian Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 9:20 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL: Alphabetizing title results in library
format
Petr Tuma wrote:
What error message it produce?
Ok, table titles is composed
Cami wrote:
Try this:
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;
Argh, that still produces
what the manual say.
Cami
-Original Message-
From: Ian Evans [mailto:[EMAIL PROTECTED]]
Sent: Thursday, November 01, 2001 9:20 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] MySQL: Alphabetizing title results in library
format
Petr Tuma wrote:
What error message it produce?
Ok, table
Hi,
seems a bit strange.
Try this select (use mysql client)
mysql select title,if(title like 'The %','yes','no') from titles;
if it works try substring functions and if that works try 'order by' clause.
It's at least working on server v. 3.23, so in case it will not work find out
in the 'list
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
--
PHP Database Mailing List (http://www.php.net/)
To