Using Substring in MySQL criteria
I'm trying to fetch all instances where the 1st letter of a person's first name is equal to P.
This is what I came up with, which doesn't return anything:
$sql="SELECT * FROM people WHERE SUBSTRING(FirstName,0,1) = 'P'";
The reason your expression doesn't work is that substring() positions are 1-based
Try either of these:
where FirstName like 'P%'
where substring(FirstName,1,1) = 'P'