Cacher is the code snippet organizer for pro developers

SELECT name, population FROM world WHERE name LIKE "Al%"

SELECT name, population FROM world WHERE name LIKE "%Al"

name = "Al%"     won't work!!!!!!