XF 1.1 Looking for a query to drop Custom Titles

[Mike54]

I am trying to get the last of the rough edges from my recent import from IPB cleaned up. I have several members with Custom Titles appearing, which seem to be remnants from IPB's user ranks.

I would like to empty the Custom Title field on all accounts. Is there a query that will accomplish this?

 

[Paul B]

UPDATE xf_user SET custom_title = ''

 

[Mike54]

That worked a treat! Many thanks for such a prompt reply!