In SQL, using the LIKE operator is a powerful way to find strings that match a certain pattern. It's suitable for most use cases, thanks to its two jolly characters: _ means any one character. %...
MySQL
How to set up AWS Audit Log plugin for MySQL 8 Community
Learn how to enable an audit log plugin on the Community version of MySQL 8 Server.
3.6 millions MySQL servers accessible from the web. Hints to keep yours secure
Shadowserver has announced that they found over 3.6 million MySQL servers exposed to the web, following their Accessible MySQL Server Report.
MariaDB/MySQL: Working with MD5 or other hashes
The optimal way to store a MD5 hashes in MariaDB, and how to work with them.
MariaDB: The “Regexp AND LIKE” optimisation
MariaDB supports regular expressions, but regexps won’t use indexes. Here’s a workaround that can be used in some cases.
How slow is SELECT * ?
The most widely known query optimisation rule is that developers should always avoid SELECT *. Even when all columns are needed, they should list their names, because more columns could be created...
Identify useless queries in MariaDB/MySQL
Some queries always fail or never return rows. They should be eliminated to improve database performance.
NULL comparisons in MariaDB, PostgreSQL, and SQLite
Comparisons are tricky when NULL values are involved. But some databases offer some special, handy syntax to solve the problem.