Countries
Retrieve countries.
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.
- Code supports the '=' operator.
SELECT * FROM Countries SELECT * FROM Countries WHERE Code = 'AF'
Columns
| Name | Type | References | Description |
| Code | String | ISO3166 alpha-2 country code. | |
| Name | String | Full name of country. | |
| StatesAggregate | String | List of states in this country. See Countries - States properties read-only |