How to change the names from table in mysql

Question

I have table called user. And it contains names like

     user
   xyz.abc
   123.abc
   atr.abc
   etc.....     

I need a query such that output should not contain the names after dot(.)

Answer 1

select rtrim(username,'.') from user 

Answer 2

You can use SUBSTRING_INDEX

SELECT SUBSTRING_INDEX(name, '.', 1) from USER;