XF 1.5 Bulk remove custom user titles

[Dark Helmet]

I recently did an import to XF 1.5 that is running pretty well. One issue that I've run across is that during the import process, users who had a title assigned by post count ladder had that title converted to a custom user title in XF. As I have around 1400 users I'd rather just bulk remove them than try to go through one-by-one, so that they'll be back to having them assigned by ladder.

I tried going through Users - Batch Update Users to achieve this, but although custom user title is a field there, leaving it blank apparently carries out no action, rather than removing them all. Is there a different way to achieve the goal of bulk removing them all?

 

[Paul B]

Run this query in phpMyAdmin:

UPDATE xf_user set custom_title = '';

Take a backup first, just in case.

 

[Dark Helmet]

Thanks, Brogan! That was spot on.