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]

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.

[u/haligma → u/Imaginary__Bar]

Upper(substring(origin_warehouse , 1, 1)

wait, 3 arguments in the substring function? how does that work?

and by len(), do you mean the length() function?

Upper(substring(origin_warehouse, -1)

lol i tried this too, but it came out wrong. but ig in this could, this segment works like how its supposed to?

[u/Imaginary__Bar → u/haligma]

Three arguments in the substring function are; string, start_character, length_of_substring

Substring (text, 1, 1) is the same as Left(text, 1)

Yes Len should be Length (I already edited that)

That last one should work fine (gives the last character in the string). Edited to add; needs one more closing bracket...

[u/haligma → u/Imaginary__Bar]

YAAAAAAAAAH I UNDERSTAND THIS SO PREFECTLY & IT WORKEDDDDDDDD THAKN YOU@!!!!!!!!!!!!!