In PostgreSQL, we can use the information_schema.views view to return all views in a database.
We can also use the \dv psql command to do the same thing.
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.
3 Ways to Return Rows that Contain Alphanumeric Characters in SQL Server
Here are three examples of returning rows that contain alphanumeric characters in SQL Server.
Alphanumeric characters are alphabetic and numeric characters.
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.
3 Ways to Find Rows that Contain Lowercase Letters in MySQL
Here are three options for returning rows that contain lowercase characters in MySQL.
2 Ways to List all Triggers in a PostgreSQL Database
Here are two options for listing out the triggers in a PostgreSQL database.
Return Just the Numeric Values from a PostgreSQL Database Column
The following PostgreSQL examples return only those rows that have numeric values in a given column.