MYSQL update text in column with data from another column

Question

Mysql database update question.

I have a table with three fields: TITLE and PARAMS and LEVEL

PARAMS column is a text field: {action="h3",and other information}

TITLE column is a text field: happy

I need to replace/update the h3 in the PARAMS column with the data from the TITLE column

So h3 will be replaced with the data in the TITLE column.

In this example, the h3 is replaced with h4.

UPDATE `m3o7x_menu` SET `params` = REPLACE(`params`, "h3", "h4") WHERE `level`='3';

What is the correct syntax to change h4 to the TITLE column data?

Thanks!

elzaer · Accepted Answer · 2013-09-27 03:41:04Z

1

UPDATE m307x_menu SET params = REPLACE(params,'h3',title) WHERE level = '3';

answered Sep 27, 2013 at 3:41

elzaer

7297 silver badges25 bronze badges

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

Comments

juergen d · Accepted Answer · 2013-09-27 03:36:54Z

1

UPDATE m3o7x_menu 
SET params = REPLACE(params, '"h3"', concat('"',title,'"') 
WHERE level='3';

answered Sep 27, 2013 at 3:36

juergen d

205k40 gold badges305 silver badges377 bronze badges

1 Comment

user1032531 Over a year ago

Don't know if this is correct, but it is what I would try first.

sunysen · Accepted Answer · 2013-09-27 05:48:40Z

1

try

UPDATE m3o7x_menu SET params = REPLACE(params, 'h3', 'h4') WHERE level='3';

edited Sep 27, 2013 at 5:48

answered Sep 27, 2013 at 3:31

sunysen

2,3711 gold badge15 silver badges13 bronze badges

2 Comments

user1032531 Over a year ago

That is identical to OP's example except you are missing a quote around h4.

user2821847 Over a year ago

I need to change h4 to the data in the TITLE field. The example replaces all instances of h3 with h4. I need to replace all instances of h3 with the data in the TITLE field.

Collectives™ on Stack Overflow

MYSQL update text in column with data from another column

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

2 Comments

Your Answer

Sign up or log in

Post as a guest

Related