MY SQL - Charindex and len

Issue: I had to select first letter from first name and everything from last name in mysql.

Solution
select concat(substring(first_name,1,1),last_name) as chars from users;