Change the interface language for many users via a database query?

[jahan_gagan]

You can’t run UPDATE queries via the Data Explorer plugin because it is strictly read-only.

For bulk updates like this, use the Rails console instead:

User.where(locale: 'en').update_all(locale: 'en_GB')

For more examples of updating user preferences in bulk, refer to:

Edit a user preference for everyone or a subset of users

This guide explains how to edit a user preference for everyone or a subset of users in Discourse. Required user level: System Administrator Console access is required. If you need to update the user preference for all of your users or a large subset of users, you can do so via the rails console. Summary In this guide, you’ll learn: How to access the Rails console for making bulk changes Examples of modifying user preferences How to identify set…