Replace multiple values - MySQL

Question

       table 1                                     table 2

+---------+------------+                    +---------+------------+
| post_id | meta_value |                    |    ID   | post_title |
+---------|------------+                    +---------|------------+
|    1    |   value_a  |                    |    1    | title_abc  |
+---------|------------+                    +---------|------------+
|    2    |   value_b  |                    |    2    | title_xyh  |
+---------|------------+                    +---------|------------+
|    3    |   value_c  |                    |    3    | title_jer  |
+---------|------------+                    +---------|------------+
| .....   | .........  |                    |   ..... |   .......  |
+---------|------------+                    +---------|------------+
|   999   | value_xyzw |                    |   999   | title_bhw  |
+---------|------------+                    +---------|------------+

I have 2 tables. I try to replace the records from post_title (table 2) with meta_value {table 1).

Example:

value_a replace title_abc

value_b replace title_xyh

value_c replace title_jer

............

etc

Thank you!

Gordon Linoff · Accepted Answer · 2014-03-22 12:43:48Z

1

You want an update with a join:

update table1 t1 join
       table2 t2
       on t1.post_id = t2.id
    set t1.meta_value = t2.post_title;

answered Mar 22, 2014 at 12:43

Gordon Linoff

1.3m62 gold badges706 silver badges857 bronze badges

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

2 Comments

user2151960 Over a year ago

i try to add another condition: meta_key = custom_title. meta_key is another column in table1

user2151960 Over a year ago

Ok. I got it: and t2.meta_key like 'custom_title'

geoB · Accepted Answer · 2014-03-22 12:45:32Z

1

UPDATE table1, table2 SET table1.metavalue = table2.post_title 
WHERE table1.id = table2.id

answered Mar 22, 2014 at 12:45

geoB

4,7287 gold badges45 silver badges75 bronze badges

Collectives™ on Stack Overflow

Replace multiple values - MySQL

2 Answers 2

2 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

2 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related