Difference between revisions of "Set a user preference"

Latest revision as of 11:07, 22 July 2019

Redirect to:

@@ Line 1: / Line 1: @@
-{{procedure
+#redirect [[MediaWiki SQL queries#Set a user preference]]
-|description = This procedure allows you to directly modify a wiki user's preference from the database
-|role = sysop
-|status = in use
-}}
-You can change a preference such as the skin with the following SQL query. Remove the WHERE clause to apply to all users.
-<pre>
-UPDATE user SET user_options = REPLACE(user_options,'skin=monobook','skin=organicdesign') WHERE user_name = 'Foo';
-</pre>