We’ll be using the MySQL built-in function char_length to demonstrate how to filter and sort based on a size of a columns width in characters.
String Concatenation Using concat Function
Unlike SQL Server, String concatenation works using a function. It’s a simple function that you pass comma separated values into in the order you want
coalesce Function Handy for Outer Joins and Nulls
The built-in function coalesce in MySQL is great for outer joins where the return or expected answer can be null. Coalesce can be used anytime
Parsing Date/Time From String
This below would parse the string, in the specified format into a valid date time object. STR_TO_DATE only works when the date mask is valid