How to concatenate a string to MySQL resultset

Question

Consider the following table:

id  foo
-----------
1   bar
2   baz
3   bat

Desired output (from SQL query):

id str_id foo
--------------
1  str1   bar
2  str2   baz
3  str3   bat

In this case, "str" is concatenated to every id. Is this possible and if so how, in MySQL?

Jason McCreary · Accepted Answer · 2012-07-16 15:38:40Z

3

Use CONCAT() to concatenate strings in MySQL.

SELECT id, CONCAT("str", id) AS str_id, foo FROM yourtable

answered Jul 16, 2012 at 15:38

Jason McCreary

73.3k23 gold badges140 silver badges177 bronze badges

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

2 Comments

Pr0no Over a year ago

LOL...so obvious I'm ashamed actually...thought it would be quite complex, using temp tables and combining them and what not

Jason McCreary Over a year ago

No worries. MySQL has a lot of functions. Might be worth it to browse the link I provided.

hjpotter92 · Accepted Answer · 2012-07-16 15:38:21Z

2

SELECT `id`, CONCAT('str', `id`) AS `str_id`, `foo`
FROM `tbl`
ORDER BY `id` ASC;

answered Jul 16, 2012 at 15:38

hjpotter92

81.1k36 gold badges148 silver badges188 bronze badges

1 Comment

Pr0no Over a year ago

I'll say it again( see below): LOL...so obvious I'm ashamed actually...thought it would be quite complex, using temp tables and combining them and what not. You were 7 secs faster so here's the accepted-answer karma. Thanks

Collectives™ on Stack Overflow

How to concatenate a string to MySQL resultset

2 Answers 2

2 Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related