LIKE operator (SQL),”in SQL — 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. select first, last, city from empinfo where first LIKE ‘Er%’;// matches any name where first name begins with Erselect first

LIKE operator (SQL),”in SQL — 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. select first, last, city from empinfo where first LIKE ‘Er%’;// matches any name where first name begins with Erselect first

last from empinfo where last LIKE ‘%s’;// matches any name with last name ending in s”