Mega Code Archive

 

Categories / MySQL Tutorial / Information Functions

 

To extract only the username part

mysql> mysql> SELECT SUBSTRING_INDEX(USER(),'@',1); +-------------------------------+ | SUBSTRING_INDEX(USER(),'@',1) | +-------------------------------+ | root                          | +-------------------------------+ 1 row in set (0.00 sec) mysql>