JDBC Driver for WordPress

Build 23.0.8839


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

Table Specific Information


The driver uses the WordPress API to process some of the filters. The driver processes other filters client-side within the driver. 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 WHERE Id IN ('130', '129')
Also, ordering by Count, Description and Name, is handled by the WordPress API.


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

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


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

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


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

DELETE FROM Categories WHERE Id = '139'


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.

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 23.0.8839