where are comments stored in the database?

Question

i have 1500 bot comment and i want to dump them where can i find it in the database?

i may want to make a plugin so work arounds are nice but i really would just want the location

Answer 1

Comments are posts like questions or answers, just with a different type. They're stored in the table qa_posts and have the value "C" in the type field (except for queued and hidden comments, which have the type "C_QUEUED" and "C_HIDDEN" respectively).