mysql - adding/concatenating text values within a SELECT clause

Question

Is there a way in MySQL to concatenate text to values using a SELECT statement? (like in Oracle)

For example, in Oracle you can write something like this:

SQL> select 'The Year is '|| year, 'The month is '|| month from time where rownum < 2;

'THEYEARIS'||YEAR
----------------------------------------------------
'THEMONTHIS'||MONTH
-----------------------------------------------------
The Year is 2009
The month is 1

Trufa · Accepted Answer · 2010-10-14 05:09:19Z

21

SELECT Concat(vend_name, ' (', vend_country, ')')
FROM vendors
ORDER BY vend_name;

Read this tutorial:

http://www.brainbell.com/tutorials/MySQL/Concatenating_Fields.htm

answered Oct 14, 2010 at 5:09

Trufa

40.9k44 gold badges133 silver badges194 bronze badges

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

Comments

JoshD · Accepted Answer · 2010-10-14 05:09:39Z

4

There is a CONCAT function in mysql.

select concat('The Year is ', year), concat('The month is ', month) from time where rownum < 2;

answered Oct 14, 2010 at 5:09

JoshD

12.9k3 gold badges46 silver badges54 bronze badges

Collectives™ on Stack Overflow

mysql - adding/concatenating text values within a SELECT clause

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related