Welcome to the Question2Answer Q&A. There's also a demo if you just want to try it out.
+4 votes
217 views
in Q2A Core by
what mysql query should I use to fetch the tag of particular question id ?

1 Answer

+1 vote
by
selected by
 
Best answer

Use a query similar to the one I suggested here, but instead of filtering for a tag-name and selecting the post ID do it the other way around:

SELECT w.word
FROM qa_posts q
  INNER JOIN qa_posttags t ON q.postid=t.postid
  INNER JOIN qa_words w ON t.wordid=w.wordid
WHERE q.postid=42;

by
Thank you so much man....
...