Comment on page
Tags
This table stores all the tags of all the posts published.
Name | Description |
comment_id | |
tag | one of the tags used to publish the post |
To retrieve all posts related to a specific tag, for example cats, you can issue the following SQL query:
SELECT
Comments.author,
Comments.permlink
FROM
Tags
INNER JOIN Comments ON Tags.comment_id = Comments.ID
WHERE
Tags.tag = 'cats'
Last modified 2yr ago