sql query to select all data start with a given letter code example

Example 1: mysql query first character

SELECT author FROM lyrics WHERE author LIKE 'B%';

Example 2: how to list all values of a column that start with a letter in sql

SELECT Name FROM Sample.MyTest WHERE Name %STARTSWITH 'M'