Delphi. 11




LIKE


LIKE . , . ( ), :

% - ( 0),

_ - .

NOT LIKE.

SELECT first_name, last_name

FROM employee

WHERE last_name LIKE "F%" ,
F

FIRST_NAME LAST_NAME

=============== ====================

Phil Forest

Pete Fisher

Roberto Ferrari

SELECT first_name, last_name

FROM employee

WHERE first_name LIKE "%er" ,
er

FIRST_NAME LAST_NAME

=============== ====================

Roger De Souza

Roger Reeves

Walter Steadman

( ) :

SELECT first_name, last_name

FROM employee

WHERE first_name LIKE "Jacq_es"
(),


es

FIRST_NAME LAST_NAME

=============== ====================

Jacques Glon

, , (%, _) ? ! ESCAPE escape?, , % _, , . Escape? \ ( ) , , , . @ ~.

SELECT first_name, last_name

FROM employee

WHERE first_name LIKE "%@_%" ESCAPE "@"
,
_
( )