Database table(s) for Prefixes

[super_dork]

I'd like to do a bulk update to the prefixes on my site but can't seem to find the table that has the prefix titles in it. The table named Prefix only has the prefix key and sort order info. Can anyone point me in the right direction?

Thanks!

[Dave]

Are we talking about thread prefixes? The actual titles are stored as phrases at the phrase manager.

[super_dork]

Yes, thread prefixes. Is phrase manager a table or just an item in the admin cp?

[Dave]

All the phrases for the thread prefixes are stored in the database like any other phrase. They are stored in the phrase table.

You can retrieve them by executing a query such as:

SELECT * 
FROM `phrase` 
WHERE varname LIKE '%_title_plain'
OR varname LIKE '%_title_rich'