Censor words database location


Can you please tell me in which DB table the censor words are stored. I have a list and I'd like to put the whole lot in with an SQL statement rather than entering each one, one at a time.



Apologies for my speeeeelling in the title of this thread. Once I spotted it it was too late to change!


Well-known member
Fixed the typo. The censor word list is stored under options in the xf_data_registry. The data is stored as a blob.

Jake Bunce

XenForo moderator
Staff member
Specifically, it's the xf_data_registry table with data_key = options. That caches all of the options including the censored words. The source data is in the xf_option table with option_id = censorWords.


Unfortunately I don't know enough SQL to cast the blob into text so I can add my profanity list and insert it back in in blob format. I guess it would be quicker to add the words one at a time. It might make me a bit more discriminating in my choice of swear and slur words.

Must remember to add lamo!

I'm a Mac boy too!


Active member
Is there any simpler way to upload list of Bad words for censoring them ??

Experts , pls guide o_O


Is there a list available in the admin console? It was easy on vBulletin, but I just can't seem to find it here.