MariaDB LIKE clause is used with SELECT, INSERT, UPDATE and DELETE statement to retrieve data when an operation needs an exact match.

Syntax:

SELECT field, field2,... FROM table_name, table_name2,...

WHERE field LIKE condition