Below are four ways to list out the views in a MariaDB database using SQL or the command line.
MariaDB
How to Get Values That Don’t Contain Numbers in MariaDB
When working with MariaDB, you may occasionally find yourself needing to return all rows that don’t contain any numbers.
Technically, numbers can be represented by words and other symbols, but for this article “number” simply means “numerical digit”. So we’re finding values that don’t contain any numerical digits.
3 Ways to Return the Modulo in MariaDB
The modulo operation returns the remainder or signed remainder of a division, after one number is divided by another.
If you need to get the modulo of a number in MariaDB, here are three options.
How to Get Multiple Rows into a Comma Separated List in SQL
Most of the major RDBMSs have a function that enables us to return our query results as a comma separated list.
That is, we can use such a function to convert each row into a separate list item, within a comma separated list.
Below are examples of how to achieve this in some of the more popular RDBMSs.
How to Return Elements from a JSON Array in MariaDB
MariaDB includes two selectors that enable us to select elements from JSON arrays:
[N]selects element number N in the array (for example,[0]to select the first element).[*]selects all elements in the array.
These can be used in a number of JSON functions that are included in MariaDB. The following examples use them with the JSON_EXTRACT() function in order to return selected array elements.
How to Return the Day Number with a Suffix in MariaDB
MariaDB includes a large collection of date and time functions that return a given date in a certain format.
One thing you can do is return the day number with the relevant “st/nd/rd/th” suffix. For example, instead of returning it as say, 10 July 2025, it’s returned as 10th July 2025.
Below is an example of adding the relevant suffix to a day number in MariaDB.
Convert Query Results to a Comma Separated List in MariaDB
In MariaDB, we can use the GROUP_CONCAT() function to return our query results as a comma separated list. By that I mean, for a given column, we can convert all rows into a single row that contains a comma separated list of the values that made up that column. Each row is a separate item in the list.
How to Return the Month and Day Names in a Different Language in MariaDB
In MariaDB, you can use the DATE_FORMAT() function to return the month name and day name from a date.
This function accepts an optional argument that let’s you specify the language that is used for the result.
4 Ways to Find Rows that Contain Lowercase Letters in MariaDB
Here are four options for returning rows that contain lowercase characters in MariaDB.
How to Subtract Hours from a Datetime Value in MariaDB
Here are some options for subtracting one or more hours from a datetime value in MariaDB.