On Thu, Nov 01, 2001 at 04:43:00AM -0500, Ian Evans wrote: > 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 >
I would do this in the php layer. -- 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]
