MySQL Tutorial/Information Functions/USER
To extract only the username part
<source lang="sql">
mysql> mysql> SELECT SUBSTRING_INDEX(USER(),"@",1); +-------------------------------+ | SUBSTRING_INDEX(USER(),"@",1) | +-------------------------------+ | root | +-------------------------------+ 1 row in set (0.00 sec) mysql></source>
USER() returns the current MySQL username and hostname
<source lang="sql">
mysql> mysql> SELECT USER(); +----------------+ | USER() | +----------------+ | root@localhost | +----------------+ 1 row in set (0.00 sec) mysql></source>