In my first post in 2023, I want to give you a summary of MariaDB 10.10. Some may argue that I'm a bit late because it was released last November, and versions 10.11 and 11.0 have been announced...
MariaDB supports several ways to compose strings dynamically. Some of them might be well-known, others aren’t familiar to you. This article covers all the ways to compose strings.
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. %...
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.