Tags

This table stores all the tags of all the posts published.

Columns

Name

Description

comment_id

a foreign key containing the ID of the post in the Comments table. (see TxComments)

tag

one of the tags used to publish the post

Query example

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'

‚Äč