Create, update, delete, and query Categories to use for categorizing your posts.

Table Specific Information

SELECT

The connector uses the WordPress API to process some of the filters. The connector processes other filters client-side within the connector. 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 Categories WHERE Parent = 0
SELECT * FROM Categories ORDER BY Id
SELECT * FROM Categories WHERE Id IN ('130', '129')

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

Insert

To insert a category the following column is required: Name.

INSERT INTO Categories (Description, Name, Parent) VALUES ('This is an example Category', 'myCategory', '138')

Update

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

UPDATE Categories SET Name = 'updatedName', Description = 'Updated description.', Parent = 137 WHERE Id = '139'

Delete

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

DELETE FROM Categories WHERE Id = '139'

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.
Parent	Integer	False	The parent term ID.