In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for ...
MariaDB
Our review of MariaDB 10.9 version, released in August 2022.
New features and performance optimisations in MariaDB 10.8 short term support release.
The optimal way to store a MD5 hashes in MariaDB, and how to work with them.
MariaDB supports regular expressions, but regexps won't use indexes. Here's a workaround that can be used in some cases.
Semantics and use cases of the WITH TIES syntax.
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB.
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...
Vettabase specialises in expert consulting and automation for your database infrastructure. We offer professional services and training for MySQL, MariaDB, PostgreSQL and Cassandra.