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
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
--
Pardon my idiocy in posting that this command gave ugly output:
select if(substring(username,1,8)='cctcpin-', lcase(trim(leading
concat(substring_index(username,'-',1), '-') from username)),
lcase(username)) as username, sec_to_time(sum(acctsessiontime))
I'm running the following:
select if(substring(username,1,8)='cctcpin-', lcase(trim(leading
concat(substring_index(username,'-',1), '-') from username)),
lcase(username)), sec_to_time(sum(acctsessiontime)) as session from
radacct where acctstarttime between '2001-04-21' and '2001-05-21' and
acct
