MyBB Community Forums
[How To?] Change existing avatar using sql query? - Printable Version

+- MyBB Community Forums (https://community.mybb.com)
+-- Forum: Community Archive (https://community.mybb.com/forum-106.html)
+--- Forum: Archived Forums (https://community.mybb.com/forum-143.html)
+---- Forum: Archived Development and Support (https://community.mybb.com/forum-155.html)
+----- Forum: MyBB 1.6 (https://community.mybb.com/forum-138.html)
+------ Forum: 1.6 General Support (https://community.mybb.com/forum-127.html)
+------ Thread: [How To?] Change existing avatar using sql query? (/thread-145971.html)



Change existing avatar using sql query? - magicm00n - 2013-09-27

Hi i have a default avatar for all users and i want to set a new default avatar but when I run this query:
UPDATE `mybb_users` SET `avatar` = '/images/new_default_avatar.jpg' WHERE `avatar` = '/images/old_default_avatar.png'
nothing happens, it doesn't change. Help!

Nvm solved.