UPDATE ubbt_USER_PROFILE SET USER_LANGUAGE='english' WHERE USER_ID=xxx
where xxx is the user id.. now if you don't want to do it once for each user and you have only ONE language (english), just do
UPDATE ubbt_USER_PROFILE SET USER_LANGUAGE='english'
that sets everyone to english, regardless..
optionally.. assume you deleted the language 'klingon' and all those users are bitching
to fix just the klingons.. do
UPDATE ubbt_USER_PROFILE SET USER_LANGUAGE='english' WHERE USER_LANGUAGE='klingon'
changes all klingons to english..