Retrieve the names of available custom fields for products.

View 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.

• Name supports the '=' operator.

Name limits the results to custom fields whose name matches the specified string.

SELECT * FROM ProductCustomfields WHERE Name = 'custom_field_name'

Columns