News:

Wondering if this will always be free?  See why free is better.

Main Menu

Simple MySQL query

Started by worldfiddler, September 22, 2022, 03:58:59 PM

Previous topic - Next topic

worldfiddler

Hello,

I am trying to find a way for a forum owner to run a few queries to extract some data for me, basically all the posts and comments I've made on that forum and output it all to a csv file.

He has database access and admin rights etc, but he not a programmer/coder as such. He referred me to this group for some help.

I'm just wanting to get the syntax correct. I can get the correct table names and fields later.

Assuming the table is [member_posts], containing field [member_name], should this query work?

SELECT * FROM member_posts WHERE member_name = 'worldfiddler'

Thanks in advance!

Jim

Sir Osis of Liver

Posts are in the messages table, default table prefix is smf_, so it would be smf_messages unless another prefix was used.  You can use poster_name or id_member to find yours.
Ashes and diamonds, foe and friend,
 we were all equal in the end.

                                     - R. Waters

worldfiddler

Thank you. I'll get him to try that.

worldfiddler


Doug Heffernan

Glad to hear that it worked. Marking this as solved.

Advertisement: