LIKE Predicate

Purpose

Special predicate

Syntax

<expression1> [NOT] LIKE <expression2>

See Also

INSERT, PREDICATES, REVERSE(), SELECT, UPDATE

Description

LIKE is a special predicate to evaluate whether the specified <expression1> matches <expression2>. The <expression2> can contain the following wildcards:

Operator	Description
_	Any single character
%	Zero or more characters

The optional NOT evaluates whether the specified <expression1> does not match <expression2>.

Note: to optimize WHERE <cExpression1> LIKE '%xxx' clauses, INDEX on the reverse character sequence of the relevant <cExpression1> using the REVERSE() function.

Example

SELECT name, address, balance, cost*1.15;
  FROM accounts;
  WHERE paid_date < date() AND name LIKE "%Inc";
  ORDER BY name, paid_date