The excess space could've come from the very long column name
of the first field.
Shrink that with an alias:
select if(substring....) AS shortname, sec_to_time( ) AS
session ...
Cheers,
Kent Hoover
filter fodder:database,sql
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
