MariaDB supports all clauses used in RDBMS. For example:

☛ MariaDB Where Clause

☛ MariaDB Like Clause

☛ MariaDB Order By Clause

☛ MariaDB DISTINCT Clause

☛ MariaDB FROM Clause

☛ Etc.