Re: MySQL: Alphabetizing title results in library format
| From: | Petr Tuma | Date: | Thu, 01 Nov 2001 05:46:53 +0000 |
| Subject: | Re: MySQL: Alphabetizing title results in library format | ||
| References: | 1 2 3 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-13899@lists.php.net to get a copy of this message | ||
Hi,
there was an typing error 'from Title' should be 'from Titles'. Anyway it's
working for me.
What error message it produce?
On Thursday 01 November 2001 05:09, you wrote:
> Petr Tuma wrote:
> > select *,(case when Title like 'The %' then substring (Title, 5, 255)
> >
> > ETC.
>
> Alas, MySQL doesn't like that syntax either. :(
--
Petr Tuma
IT Manager, M.Ward Manufacturing