Tags
Create,Update,List and Delete the Tags for the WordPressOnline website.
Table Specific Information
SELECT
The driver uses the WordPress API to process some of the filters.
- Slug supports the '=' comparison.
The driver processes other filters client-side within the driver.
For example, the following queries are processed server side.
SELECT * FROM Tags
SELECT * FROM Tags WHERE Slug='tagTest'
Insert
To insert a tag, following columns are required : Name
INSERT INTO Tags (Slug, Name, Description) VALUES ('tagtest', 'Tag name', 'Tag Description')
Update
To update a tag you must specify the following column: Slug.
UPDATE Tags SET Name= 'Modified tag name', Description = 'Modified tag description' WHERE Slug='tagTest'
Delete
To delete a tag you must specify the following column: Slug.
DELETE FROM Tags WHERE Slug='tagTest'
Columns
| Name | Type | ReadOnly | References | Description |
| Slug [KEY] | String | True |
The URL-friendly identifier (slug) for the tag. | |
| ID | Int | True |
The unique numeric identifier assigned to the tag. | |
| Name | String | False |
The display name of the tag as shown in WordPress. | |
| Description | String | False |
A brief explanation or summary of what the tag represents. | |
| FeedUrl | String | False |
The RSS feed URL associated with this tag. | |
| PostCount | Int | False |
The total number of posts currently assigned to this tag. |