ODBC Driver for WordPress

Build 24.0.9060

Members

Create, update, delete, and list the Members of the website.

Table Specific Information

SELECT

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 Members WHERE Id = 10

Update

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

UPDATE Members SET Title = 'updatedName' WHERE Id = '139'

Delete

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

DELETE FROM Members WHERE Id = '139'

Columns

Name Type ReadOnly Description
Id [KEY] Integer True

Unique identifier for the post

Date Datetime False

The date the post was created in the site's timezone

DateGMT Datetime False

Date in the GMT format

Slug String False

Slug Type

Status String False

A named status for the post

Title Object False

The title for the post

Link String False

Member link

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