UBB.Developers Forums UBB.threads 7 Development How Do I? Need to mass-change custom user titles

Is there some relatively simple PHP code to change everyone with a specific custom title (for the sake of example, let's say "Widget" or "Gizmo") to another title that I'd specify (say, "Doohickey")?

I've got a bunch of users with 6 different custom titles, based around their class in an RPG game, but we're moving on from that game, and want to change all of the various 6 titles to one singular title. I'm fine with running 6 different commands to change them all. I'm not so fine with going through and changing the titles by hand for 200 users . . .

you can usually find what you're looking for here

https://www.ubbdev.com/forum/showflat...5/o/all/fpart/1

but

UPDATE `w3t_Users`
SET `U_Title` = 'Doohickey'
WHERE `U_Title` = 'Widget' || `U_Title` = 'Gizmo'

change the FROM `w3t_Users`
to your table extension, mine's w3t_

Thank you. That seems to have done precisely the trick.