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 the same syntax error. Our hosting company is using MySQL 3.22.32 if that's any help. -- Ian Evans Digital Hit Entertainment - News and Information http://www.digitalhit.com -- 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]
