Information Functions MySQL Tutorial

  1. Home
  2. MySQL Tutorial
  3. Information Functions
  4. 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>