MYSQL Join on meta key value?

You can update just joining both table on comparing same userid. like: 

update t1 join
       t2
       on t1.user_id = t2.user_id
    set t1.meta_value = t2.desc;

Related Posts:

  1. Access denied for user ‘root@localhost’ (using password:NO)
  2. MySQL error 2006: mysql server has gone away
  3. Which MySQL data type to use for storing boolean values
  4. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  5. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  6. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  7. Your password does not satisfy the current policy requirements
  8. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  9. What is the definition of cardinality in SQL
  10. what does “/index.php?admin/admin_dashboard” in my url mean
  11. How to join two tables by multiple columns in SQL?
  12. How to get size of mysql database?
  13. Selecting data from two different tables without using joins
  14. SQL – Update multiple records in one query
  15. MySQL Error 1093 – Can’t specify target table for update in FROM clause
  16. mysqladmin: connect to server at ‘localhost’ failed
  17. mysql update multiple columns with same now()
  18. Usage of MySQL’s “IF EXISTS”
  19. How can I loop through all rows of a table? (MySQL)
  20. Simple Random Samples from a Sql database
  21. Generating a random & unique 8 character string using MySQL
  22. MySQL > Table doesn’t exist. But it does (or it should)
  23. SQL select only rows with max value on a column
  24. Trying to perform MINUS operation in MySQL
  25. Getting java.sql.SQLException: Operation not allowed after ResultSet closed
  26. mysql count duplicates
  27. phpmyadmin #1045 Cannot log in to the MySQL server. after installing mysql command line client
  28. MySQL config file location – redhat linux server
  29. How to create a foreign key in phpmyadmin
  30. Can’t create test file lower test start server mysql
  31. MySQL delete multiple rows in one query conditions unique to each row
  32. Create boolean column in MySQL with false as default value?
  33. SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
  34. Is there a naming convention for MySQL?
  35. CAST to DECIMAL in MySQL
  36. Is merge statement available in MySQL
  37. GROUP_CONCAT comma separator – MySQL
  38. Failed to Connect to MySQL at localhost:3306 with user root
  39. How do you properly prepare a %LIKE% SQL statement?
  40. Set page template for all pages?
  41. SQL query to update post_date (one post = one single date & time)
  42. My WordPress site always displays a cached version of its homepage
  43. How to copy post titles to post slug in phpmyadmin
  44. If I consider changing my WordPress DB tables to InnoDB, will it have an effect on the way WordPress works?
  45. Proper way to work with wpdb to get user’s firstname
  46. Inserting Hundreds of Thousands of Posts at Once
  47. wp_admin edit.php slow with lots of queries
  48. Database: Custom table: sprintf value for DateTime column
  49. can database and media folder be moved to a different drive?
  50. What is the most secure way to set up the MySQL user in WPMU?
  51. Find duplicate posts with same slug and author
  52. WP_USE_EXT_MYSQL
  53. Distinction on meta value on pre_get_posts
  54. How to get data from WordPress site sql file
  55. WordPress with php5-fpm and nginx
  56. MySQL Rank & $wpdb
  57. When WordPress Default table, Echo Success. When Plugin Table, Echo Blank
  58. WordPress post_status is future, manually added
  59. How are multiple WordPress WPDB queries handled?
  60. $wpdb to insert html form information
  61. Proper usage of $wpdb->update()?
  62. Regarding “Insert query error” in wordpress
  63. MySQL 5.5 upgrade ‘broke’ WordPress [closed]
  64. WordPress plugin overloading with tmp tables
  65. Site not responding error – taking long to load [closed]
  66. What should a WordPress developer know about MySQL? [closed]
  67. Copyright: Get first and last date of post type
  68. WordPress(wpdb class) and mysql stored procedures
  69. WordPress plugins for database queries
  70. WordPress doesn’t display accents after migration
  71. Query posts by custom taxonomy and sort by post_modified
  72. WordPress $wpdb get posts from category and sort by custom meta
  73. Replace a character in all post titles and slugs
  74. Understanding custom php that reads from WP MYSQL
  75. $wpdb->get_var multiple queries in one database check
  76. List users with the most posts in the last 30 days
  77. Way to extract wordpress data from folder backup
  78. Data is not constatntly loading from custom wordpress table
  79. Mysql Server keeps crashing
  80. when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
  81. How to search usermeta table
  82. How to add virtual column in wpdb get_result statement
  83. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  84. I want to share local developement and staging DB — Is this very smart or very stupid?
  85. Extract all users along with yoast metadata description
  86. WordPress asks to install, but is already installed?
  87. Mysql Error in querying form entries in Gravity Form plugin
  88. Deleting a table row through query
  89. An SQL query to find orphaned image attachments and their meta
  90. Weird characters displayed when importing WordPress MySQL db
  91. Simple SQL Query in wordpress
  92. MySQL errors after a WordPress clone
  93. optimise SQL wordpress call
  94. Woocommerce: Grab total revenue of a product over all orders
  95. Complicated MySQL Query
  96. problem with quotes on new post
  97. Where other than wp-config can database access details be defined?
  98. Why does the MySQL command line tool ignore the –port parameter?
  99. Postgres equivalent to MySQL’s \G?
  100. Possible SQL injection. How to locate and fix?
error code: 523