Mysql append column value

Question

I am having the table with the following structure

      ----------------------------
       id                  content
      ---------------------------
        1                   abc
        2                   bca
      ---------------------------

I want to append the character 'd' with the field 'content' ... So i want the table structure as follows

       ----------------------------
       id                  content
      ---------------------------
        1                   abcd
        2                   bca
      ---------------------------

How can i do this..

possible duplicate of How to prepend a string to a column value in MySQL? — magdmartin
– magdmartin, Commented Oct 29, 2013 at 18:37

Dhinakar · Accepted Answer · 2012-12-18 04:39:58Z

37

If you want update the column from the Table then use below Query

update table1 set content = concat(content,'d');

If you want to select the column concatenation with 'd; the use below Query

select id, concat(content,'d') as content from table1;

Refer :

http://sqlfiddle.com/#!2/099c8/1

answered Dec 18, 2012 at 4:39

Dhinakar

4,1267 gold badges39 silver badges69 bronze badges

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

Comments

Mahmoud Gamal · Accepted Answer · 2012-12-18 04:27:36Z

17

You can use the CONCAT, like so

SELECT 
  id,
  CONCAT(content, 'd') content
FROM tablename;

You can also specify a WHERE clause to determine which rows to update. Something like:

SELECT 
  id,
  CONCAT(content, 'd') content
FROM tablename
WHERE id = 1;

answered Dec 18, 2012 at 4:27

Mahmoud Gamal

80.2k18 gold badges143 silver badges168 bronze badges

2 Comments

xkeshav Over a year ago

+1 for quick answer. But this will add d to that specific column in all row and OP doesn't mentioned this

Mahmoud Gamal Over a year ago

@diEcho I updated my answer. But the question is lack more information about what exactly the OP is trying to do.

Collectives™ on Stack Overflow

Mysql append column value

2 Answers 2

Comments

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related