HiveSQL
Search…
Introduction
Register your HiveSQL account
Support
Technical informations
Database Diagram
Operations
Virtual Operations
State tables
DynamicGlobalProperties
Accounts
Blacklists
BlacklistsFollows
Comments
Communities
CommunitiesRoles
CommunitiesSubscribers
Delegations
Followers
Mutes
MutesFollows
Proposals
ProposalsApprovals
Reblogs
Tags
Witnesses
Full Text Search
Language detection
Tutorials
HiveSQL for Python developers
HiveSQL for PHP developers
HiveSQL for Ruby developers
HiveSQL for Microsoft Excel
HiveSQL Status
Resources
Powered By
GitBook
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!
​
Previous
Reblogs
Next
Witnesses
Last modified
11mo ago
Copy link
Contents