MariaDB supports regular expressions, but regexps won't use indexes. Here's a workaround that can be used in some cases.
Read our expert blog with articles on MariaDB, MySQL, PostgreSQL, Cassandra and related tools & technologies.
Databases and technical debts: here's a list of requirements your database infrastructure should have.
Semantics and use cases of the WITH TIES syntax.
How to remote duplicate values from a table to add a UNIQUE index, in MariaDB.
Periodical maintenance windows can be healthy both for your team and your infrastructure. Business won't be damaged.
Before introducing a new database technology in your organisation, consider the drawbacks.
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all ...
Some queries always fail or never return rows. They should be eliminated to improve database performance.