How to export part of a Database

#1
So our xenforo site is a sports site associated with a university. A Student from the university would like to use all the posts from our football (American football) in a research paper.

I know all the board posts are located in xf_posts but can I just pull just the posts or do I need to xport the whole thing? I really would like to just send him the column of posts from football board with out user names.
 
#2
Hi Huskermax,

if you want to select single column from xf_post table use this query

SQL:
select message from xf_post
and click export button at the bottom of page, it will export the results
 

Attachments

Top