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

[Richie (Richie Rich)]

Thanks @jahan_gagan

I took a DB backup first

I then ran this:

@jahan_gagan

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

It worked perfectly:

Loading production environment (Rails 8.0.4)
discourse(prod)> User.where(locale: 'en').update_all(locale: 'en_GB')
=> 16016

And my Data Explorer query now responds with:

locale	user_count
en_GB	35493

Thank you