MYSQL filtering conditionally on first 2 characters
I have a table of Outcodes (in the UK, the first part of postcodes/zipcode) for example id,outcode 1, AB1 2, AB2... and so on 27, AL1 28, AL2...and so on 52, B1 52, B2 52, B3 61, BA1 etc. I…
I have a table of Outcodes (in the UK, the first part of postcodes/zipcode) for example id,outcode 1, AB1 2, AB2... and so on 27, AL1 28, AL2...and so on 52, B1 52, B2 52, B3 61, BA1 etc. I…
How can I to force the input of the postcode field in WooCommerce account page into upper case, so if someone inputs rh12 3uc it makes it into RH12 3UC?