Create, update, delete, and query Tags to associate with your posts.

Table Specific Information

Select

The add-in uses the WordPress API to process supported filters. The add-in processes other filters client-side within the add-in. For example, the following queries are processed server side.

SELECT * FROM Tags WHERE Id NOT IN ('8', '9')
SELECT * FROM Tags WHERE Id = 5
SELECT * FROM Tags ORDER BY Id

Also, ordering by Count, Description, and Name is handled by the WordPress API.

Insert

To insert a tag you must specify the following column: Name.

INSERT INTO Tags (Name, Description) VALUES ('MyTag', 'A tag')

Update

To update a tag you must specify the following column: Id.

UPDATE Tags SET Name = 'Updated name', Description = 'Updated description' WHERE Id = '12345'

Delete

To delete a tag you must specify the following column: Id.

DELETE FROM Tags WHERE Id = '12345'

Columns

Name	Type	ReadOnly	References	Description
Id [KEY]	Integer	True		The unique identifier of the tag in WordPress.
Count	Integer	True		The total number of published posts associated with this tag.
Description	String	False		The descriptive text or explanation for the tag, often displayed on tag archive pages.
Link	String	True		The permalink URL for viewing all posts associated with this tag on the WordPress site.
Name	String	False		The display name of the tag as shown in the WordPress admin area or on the site.
Taxonomy	String	True		Specifies the taxonomy type for the term, which for tags is typically 'post_tag'.