Retrieve the terms for an attribute.

Table Specific Information

Select

WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query. Following columns are supported server side, all other columns are processed client side. If the 'AttributeId' filter is not specified, the server will fetch a list of all the attributes and perform a request for each attribute in the list.

• Id supports the '=,IN,NOT IN' operators.
• Slug supports the '=' operator.
• AttributeId supports the '=' operator.
• ProductId supports the '=' operator.

SELECT * FROM ProductAttributeTerms WHERE Id IN (4,5)
SELECT * FROM ProductAttributeTerms WHERE AttributeId = 4
SELECT * FROM ProductAttributeTerms WHERE ProductId = 41 AND Slug = 'criteria'

Insert

The following attributes are required when performing an insert: Name, AttributeId.

INSERT INTO ProductAttributeTerms (Name, AttributeId) VALUES ('term_name', 2)

Columns