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. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause inconsistent data. 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	Description
Id [KEY]	Integer	True	Unique identifier for the term.
Count	Integer	True	Number of published posts for the term.
Description	String	False	HTML description of the term.
Link	String	True	URL of the term.
Name	String	False	HTML title for the term.
Taxonomy	String	True	Type attribution for the term.