How to export part of a Database

[Huskermax]

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.

 

[wagrasol]

Hi Huskermax,

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

select message from xf_post

and click export button at the bottom of page, it will export the results