Using SELECT CONCAT in MySQL returns the CONCAT command as well in Bash

Question

This is the SQL statement:

mysql -u user -p password -e  "SELECT concat(name,'-',number) from users 
where email='[email protected]'"

Expected output: john-1234

Actual output: concat(name,'-',number)
               john-1234

Why is this happening?

That's the column name. Try `... concat(name,'-',number) as XYZ ...` and see what happens. — jarlh, Feb 14 '19 at 10:28
I'm using this command in bash and it's extra work to split the output. Is there a way that I can only return the result? — Barath R, Feb 14 '19 at 10:30

score 0 · Answer 1 · answered Feb 14 '19 at 10:29

0

MySQL will return column names. You can give it a more useful alias like this:

SELECT concat(name,'-',number) as username from users 
where email='[email protected]'

EDIT: Looks like @jarlh beat me to it in the comments.

answered Feb 14 '19 at 10:29

Jim Wright

5,905
1
15
34

score 0 · Answer 2 · answered Feb 14 '19 at 10:29

0

just give an alias of your column name other wise it will concat(name,'-',number) as column name

"SELECT concat(name,'-',number) as output from users 
where email='[email protected]'"

answered Feb 14 '19 at 10:29

Zaynul Abadin Tuhin

31,407
5
33
63

score 0 · Answer 3 · answered Feb 14 '19 at 10:29

0

It is name of the column.

You can name it in other way:

SELECT concat(name,'-',number) AS nameAndNumber from users where email='[email protected]'

answered Feb 14 '19 at 10:29

Vlad Hanzha

464
3
11

Using SELECT CONCAT in MySQL returns the CONCAT command as well in Bash

3 Answers3