first letter capital in mysql query 1

first letter capital in mysql query

select initcap("hometown")                     hometown, is the column name
FROM benn.college_football_players

Here is what the above code is Doing:
1. We’re selecting the column “hometown” from the table “college_football_players” in the database “benn”.
2. We’re using the function “initcap” to capitalize the first letter of each word in the column “hometown”.

Similar Posts