php code for selecting one by one letters from a variable code example

Example 1: mysql query first character

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

Example 2: take 10 character from string using php

$return_string = substr("Hi i am returning first 10 characters.", 0, 10);
Output:
"Hi i am re"