MySQL – Regular expression replace

MSQL, mysql, REGEX, SQL

As of MySQL 8.0 and MariaDB 10 we can use  native REGEXP_REPLACE function. See also See MariaDB docs and PCRE Regular expression enhancements. — REGEXP_REPLACE(col, regexp, replace) SELECT REGEXP_REPLACE(“stackoverflow”,...

Mysql utf8_general_ci vs utf8_unicode_ci

MSQL, mysql, SQL

Why to use utf8_unicode_ci over utf8_general_ci, or simple why never not to use utf8_general_ci. Basically utf8_general_ci is a broken version of utf8_unicode_ci. It is slightly faster bit only a little bit and it can produce unexpected result while sorting or...

MySQL (MariaDB) – Appointment Database Schema

MSQL, SQL

In this blog post, you will be presented with MySQL booking database schema. You will also see examples of SQL calls to insert and validate a new booking request. At the end of this post, you will find the post on the logic behind this database and SQL queries...

SQL JOIN TUTORIAL

*, IT, MSQL, SQL

The above diagram can not fully represent JOIN charasteristicks due to its limitations. MySQL JOIN – (INNER JOIN) query result description characteristics:sequence – dos not matterchaining – dos not mater MySQL LEFT JOIN – (LEFT OUTER JOIN)...