Select statement query

[Dawie]

Hi,
I have a simple table:
id surname
1 gastrow
2 gilmer
3 green
4 greenwood
5 gunther
(sorted in surname)
When the user types in "gr" and clicks "go" the select statement should return "green" and "greenwood" I'm using:
"SELECT * FROM table WHERE surname >= '$surname'"
but this also returns "gunther" which is incorrect.
Anybody with advice please?
Thanks

[Norman_Graham]

Hi Dawie

I believe the >= operator is a numerical operator, i.e. it compares numbers. MySQL can't know what it is you want to compare here.

You need some string-comparison functions:
http://www.mysql.com/doc/en/String_comparison_functions.html

HTH

Norm

[superwormy]

Indeed, use LIKE or = instead.