Tags - HiveSQL

Search…

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:
1
SELECT
2
    Comments.author, 
3
    Comments.permlink
4
FROM
5
    Tags
6
    INNER JOIN Comments ON Tags.comment_id = Comments.ID
7
WHERE
8
    Tags.tag = 'cats'
Copied!
​

Reblogs

Witnesses

Last modified 4mo ago

Copy link