Tagged: SUBSTRING

SQL

How to Capitalize the First Letter of a String in MySQL

When working with text data in MySQL, you may encounter strings with inconsistent capitalization. For example, a database might contain values such as: grizzliesmavericksCAVALIERSSpurshawKsnets For reporting, dashboards, applications, and data-cleaning workflows, you may want...

SQL

MySQL Limit the Number of Characters Returned

MySQL Limit the Number of Characters Returned, you may sometimes need to truncate a string and return only a specific number of characters from a column. For example, suppose a table contains team names...