PPT Slide
select firstname, lastname, city from snv_Class where firstname LIKE ’T%’;
The LIKE pattern matching operator can also be used in the conditional selection of the where clause. Like is a very powerful character string comparison operator that allows you to select only rows that are "like" what you specify. The percent sign "%" can be used as a wild card to match any possible character that might appear before or after the characters specified.
Like operator koristi indekse. Ne preporucuje se upotreba
LIKE ‘%T%’ kod velikih tabela;