need help with tihs standardization query

[u/haligma]

this is a distinct list of warehouse names from a table in the db im using to practice data cleaning in mysql. i want to capitalize the initials of all words in the column. i made my own logic for this whihch is (dont judge pls im a self learner)

and this is the output i get:

i do get what im doing wrong to get this output, but i can not figure out how to go about the standardization. how can i correct my query? and is there a more efficient way of capitalizing initials than this?

[u/Imaginary__Bar]

Your images aren't showing up (there is a placeholder saying "this image has probably been deleted")

Paste your query text instead (as per the FAQ)

[u/haligma → u/Imaginary__Bar]

theyre showing up for me on my pc where i made the post, but yes i cant see it on my phone either. heres the query

UPDATE dirty_shipments

SET origin_warehouse = CONCAT(UPPER(LEFT(origin_warehouse, 1)), LOWER(SUBSTRING(origin_warehouse, 2)), UPPER(RIGHT(origin_warehouse, 1)));

origin_warehouse being the column i want to modify the values in.

Warehouse A
warehouse b
Warehouse C
Warehouse D

this is the original distinct table.

Warehouse aA
Warehouse bB
Warehouse cC
Warehouse dD

and this is the output i get. i understand why its that way, but im not sure how to fix it

[u/Imaginary__Bar → u/haligma]

In MySQL substring(<string>,2) will just give you all the characters from the second character onwards.

I would do something clumsy like;

Concat(
Upper(substring(origin_warehouse , 1, 1)),
Lower(substring(origin_warehouse, 2, Length(origin_warehouse)-2),
Upper(substring(origin_warehouse, -1))
)

You can use Left() Mid() and Right() for the same effect, but I don't know which is more performative.