Suggest a feature
×

Welcome to TagMyCode

Please login or create account to add a snippet.
0
0
 
0
Language: SQL
Posted by: Ebraheem Bdarni
Added: Jul 20, 2020 9:01 PM
Views: 103
  1. SELECT DISTINCT a.* FROM anbago.articles a
  2. INNER JOIN anbago.article_hashtag ah ON a.id = ah.article_id
  3. INNER JOIN anbago.hashtags h ON h.id = ah.hashtag_id
  4. WHERE h.name IN ("hashtag1","hashtag2","hashtag3");