55)
when Title like 'A %' then substring (Title, 3, 255)
when Title like 'An %' then substring (Title, 4, 255)
else Title
end
That worked like a charm, yet MySQL doesn't seem to accept that. Any
solutions or advice?
--
Ian Evans
Digital Hit Entertainment - News and Info
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 (ht
then
substring (title, 5, 255) when title like 'A %' the' at line 1
--
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-
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