Thread prefix name

[luutruong]

I try to find "thread prefix name" in database xenforo but i cant find it.
Please help

 

[luutruong]

updating.......
Please help

 

[Jake Bunce]

Replied to your PM.

The actual prefix names are stored as phrases. Run this query:

SELECT *
FROM xf_phrase
WHERE title LIKE 'thread_prefix%'

 

[luutruong]

Thanks Jake, but not useful with me
how can i get thread prefix name by Thread Prefix_id with SQL query

 

[Jake Bunce]

SELECT phrase_text
FROM xf_phrase
WHERE title = 'thread_prefix_1'

Use the prefix_id.

 

[luutruong]

SELECT phrase_text
FROM xf_phrase
WHERE title = 'thread_prefix_1'

Use the prefix_id.

great...this is useful with me..
Thank Jake,