Menu
CodeSprout
Typo-tolerant search across every article, problem and post. to open

1667. Fix Names in a Table โ€“ Clean & Format Strings in SQL ๐Ÿงผ

kvi5hnu2 minutes 38 secondsWatch on YouTube
0comments

Notes

In this video, we solve the "Fix Names in a Table" problem from LeetCode using MySQL. Learn how to clean up and format names so each one starts with an uppercase letter followed by lowercase characters โ€” a common real-world data cleanup task!

๐Ÿ“Œ What Youโ€™ll Learn in This Video:
โœ… How to use UPPER() and LOWER() functions for string formatting
โœ… Working with SUBSTRING() in SQL
โœ… How to apply transformations column-wise
โœ… Building readable SQL queries for data cleaning
โœ… Real-world string manipulation techniques in MySQL

๐Ÿ”— LeetCode Problem:
https://leetcode.com/problems/fix-names-in-a-table

๐Ÿ”ฅ If this video helps you:
๐Ÿ‘ Like the video to support the channel
๐Ÿ’ฌ Comment below with your thoughts or questions
๐Ÿ”” Subscribe for more SQL tutorials and challenges!

Letโ€™s clean and master your sql skills together! ๐Ÿš€

#SQL #MySQL #LeetCode #FixNames #StringFormatting #SQLQueries #DataCleaning #LearnSQL #LeetCodeSQL #SQLInterview #DatabaseSkills #SQLShorts #sql50

Discussion

Sign in to ask a question or share what you learned.