• This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn more.

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.


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!