How do I select all records where something starts with an A

[Dark Lord]

I got as far as:

Select * from `Persons` WHERE `vn` LIKE \'$vn\'

 

but that only selects the ones that are equal to $vn and not the ones starting with $vn... how do i get it to select the ones starting with $vn???

[Kriek]

Use the wildcard % characters.

 

SELECT * FROM Persons WHERE vn LIKE \'%$vn%\';

[michael yare]

If he does that Jon, he will get everything with $vn in - starting, middle or ending.

 

He wants:

 

LIKE \'$vn%\'