MySQL string and concat

Question

So I want to take the first letter of the first name and all of the last name, add them together and make that the person's username.

I was using CONCAT() and I keep getting an unexplained syntax error from MySQL.

I have:

SELECT 
CONCAT(left(first_name, 1), left(last_name)) username
FROM survey_responders;

And all I get is "Syntax Error" as my error. What am I doing wrong?

Doesn't LEFT require two parameters? What happens when you use left (last_name,1) instead of left(last_name)? — J A
– J A, Commented Mar 23, 2015 at 19:34

Dan · Accepted Answer · 2015-03-23 19:35:22Z

1

You are missing the second argument for left(last_name), but I don't even think you need that call to left since you want the whole thing. So:

SELECT 
CONCAT(left(first_name, 1), last_name) username
FROM survey_responders;

answered Mar 23, 2015 at 19:35

Dan

11.2k5 gold badges26 silver badges36 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Ola · Accepted Answer · 2015-03-23 21:25:55Z

0

The function left is good but substr is more efficient, try this instead:

select concat(substr(first_name, 1, 1), last_name) username FROM survey_responders;

answered Mar 23, 2015 at 21:25

Ola

684 bronze badges