Prefixes mysql

[Robert9]

I have a big problem with sorting my prefixes, because i just have to many of them.
Now i tried to find the places in mysql to write a small script sorting them for my needs.

So i have watched the tables for prefixes and phrases, but i still have no idea how they are connected?

May someone tell me the right place to find it, please?

 

[wagrasol]

I hope it is solved by now.In case anyone else is looking for answer to this.

In xf_thread table the second last column i.e prefix_id links with the id of table xf_thread_prefix(a table that contains all the prefixes created).

Make sure to take the db backup before applying direct mysql queries.