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..

Answer 1

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

Answer 2

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;