Media
Create, update, delete, and query Media to attach in your posts.
Table Specific Information
Select
The 本製品 uses the WordPress API to process supported filters. The 本製品 processes other filters client-side within the 本製品. 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.
Note : Status column only accepts the following values for select operation: inherit and private.
For example, the following queries are processed server side.
SELECT * FROM Media WHERE Id IN ('1176', '1175') SELECT * FROM Media WHERE Id = '1176' SELECT * FROM Media WHERE AuthorId IN (1, 2) SELECT * FROM Media WHERE MimeType = 'image/jpeg' SELECT * FROM Media WHERE Status = 'Inherit' SELECT * FROM Media WHERE Date < '2018-02-02T02:02:23' SELECT * FROM Media WHERE Date > '2018-02-02T02:02:23' SELECT * FROM Media ORDER BY IdAlso, ordering by Date, Modified, and AuthorId is handled by the WordPress API.
Insert and Update
Note : Status column only accepts the following values for insert and update operations: publish, future, draft, pending, and private.
To insert a media you must specify the following column: FileLocation.
INSERT INTO Media (Title, FileLocation, Caption) VALUES ('MediaTitle', 'C:/myImages/image.png', 'This is an uploaded media.')
To update a media you must specify the following column: Id.
UPDATE Media SET Title = 'Updated Title' WHERE Id = '4'Other fields that you can use on INSERT and UPDATE queries are: Date, DateGMT, Status, Title, AuthorId, CommentStatus, PingStatus, Caption, Description, PostId.
Delete
To delete a media you must specify the following column: Id.
DELETE FROM Media WHERE Id = '1234'
Columns
Name | Type | ReadOnly | Description |
Id [KEY] | Integer | True |
Unique identifier for the object. |
Title | String | False |
The title for the object. |
Date | Datetime | False |
The date the object was published, in the site's timezone. |
DateGMT | Datetime | False |
The date the object was published, as GMT. |
Modified | Datetime | True |
The date the object was last modified, in the site's timezone. |
ModifiedGMT | Datetime | True |
The date the object was last modified, as GMT. |
Status | String | False |
A named status for the object. |
Type | String | True |
Type of Post for the object. |
AuthorId | Integer | False |
The ID for the author of the object. |
CommentStatus | String | False |
Whether or not comments are open on the object. |
PingStatus | String | False |
Whether or not the object can be pinged. |
Caption | String | False |
The attachment caption. |
Description | String | False |
The attachment description. |
MediaType | String | True |
Attachment type. |
MimeType | String | True |
The attachment MIME type. |
PostId | Integer | False |
The ID for the associated post of the attachment. |
SourceUrl | String | True |
URL to the original attachment file. |
Link | String | True |
URL to the object. |
Pseudo-Columns
Name | Type | Description |
FileLocation | String |
The location of the file to be uploaded. |