States
Retrieve shipping states.
Table Specific Information
Select
WooCommerce allows only a small subset of columns to be used in the WHERE clause of a SELECT query.
These columns support only the = comparison, unless stated otherwise. The available column for this
table is: Country. All other columns are processed client side. If the 'Country' filter is not specified,
the cmdlet will fetch a list of all the countries and perform a request for each country in the list.
SELECT * FROM States WHERE Country = 'Germany'
Columns
Name | Type | Description |
Country | String | State code. |
Code | String | State code. |
Name | String | Full name of the state. |