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.
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
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
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