You are here

LIKE - Search String Matching

Syntax

Description:

    LIKE is used only with CHAR and VARCHAR field types. Folowing rules apply to the format string :
    _ (underline) means all characters are allowed at this place;
    % (percent) means all character combinations (more than one character too) are allowed at this place (wildcard)

    Example:

SELECT *
 FROM tkunden
 WHERE kname LIKE 'G%';

Select all customers whith an beginning 'G' in the name.