MySQL – Regular expression replace

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

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

Database Schema under revision: codreview: https://codereview.stackexchange.com/questions/263965/appointment-database-design-ii github: https://github.com/DevWL/Appointment-DB Query database: DROP DATABASE IF EXISTS bookings; CREATE DATABASE bookings CHARACTER SET =...

SQL JOIN TUTORIAL

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

Turn off / Disable modules in PrestaShop using SQL

Reading this article you will learn what are default prestashop module and how to disable non default modules or any module of your choice using simple SQL query. Default modules list installed with PrestaShop 1.7.7.5 SELECT GROUP_CONCAT(name ORDER BY id_module...