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 -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] To contact the list administrators, e-mail: [EMAIL PROTECTED]