LIKE Predicate

From Recital Documentation Wiki
Revision as of 17:20, 22 December 2009 by Yvonnemilne (Talk | contribs)

Jump to: navigation, search

Purpose

Special predicate


Syntax

<expression1> [NOT] LIKE <expression2>


See Also

PREDICATES, INSERT, 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>.


Example

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


Products

Recital, Recital Server