Timeline for Updating multiple mysql rows where column has specific value
Current License: CC BY-SA 3.0
3 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Dec 3, 2015 at 23:59 | vote | accept | JediTricks007 | ||
| Dec 3, 2015 at 18:37 | comment | added | JediTricks007 | Hey thank you very much. This is great and pointed me in right direction. This is very simple solution and works well. Only issue is that 1 user ID can have many meta values so I had to make the query little more specific otherwise it overwrote all the other meta values which are unrelated to the twitter photo. UPDATE wp_usermeta, temp SET wp_usermeta.meta_value = temp.meta_value WHERE wp_usermeta.user_id = temp.user_id AND wp_usermeta.meta_key LIKE 'twitter_photo'; Feel free to update that second part and will accept answer. | |
| Dec 3, 2015 at 6:44 | history | answered | mysql_user | CC BY-SA 3.0 |