MySQL how to split and/or transform a string
In this article you can see how to split strings
SQL Basics
MySQL 8 how to select day, month and year from date
Or how to format the date into different output templates.
Count words and phrases in a column MySQL/SQL
In this post:
* MySQL Count words in a column per
MySQL select min and max length of all table columns
If you want to query min and max length of
mysql select N max values per group
In this post:
* Get N numbers per group
* Get N
Group by and string concatenation in Oracle and MySQL
It's a common operation in DB to have
MySQL How to find highest and lowest value
If you want to find the highest or the lowest
SQL Count not null values in every table column
In this post:
* SQL count null and not null values