wHERE CustomerName LIKE ‘a%’;

MySQL LIKE Operator The LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are  % wildcards often used in conjunction with the LIKE operator: % – The percent sign represents zero, one, or multiple characters _ – The underscore represents a single character   SELECT column1, column2, … Read more