Answered: what mysql query should I use to fetch the tag of particular question id ?

Post date: 2021-04-16 21:04:49
Views: 87

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;

Please click Here to read the full story.
 
Other Top and Latest Questions:
Looking for an anime soccer cartoon
Best of 'Included in your (Audible) subscription'?
Five tech stocks with upside worthy of buying ahead of earnings, Wells Fargo says
Israel says 300 Iranian drones and missiles downed in ‘unprecedented’ overnight attack
The 14 U.S. states where you can still afford to buy a home if you earn less than $75,000
Answered: Cookie Popup for GDPR Cookie Consent: Best Practices
Answered: Is there any best and free premium theme and also mobile friendly ?
Fallout: The Head
Movie: Spy x Family Code: White
Frieren: Beyond Journey's End: Well-Laid Plans