In this article you can see how to split strings
Or how to format the date into different output templates.
In this post: * MySQL Count words in a column per
If you want to query min and max length of
In this post: * Get N numbers per group * Get N
It's a common operation in DB to have a need
If you want to find the highest or the lowest
In this post: * SQL count null and not null values