Posted by mick white on 06/12/06 23:17

Andy George wrote:

> $query="SELECT * FROM table where the first name starts with $letter";
>
> How would you do this?
>
> Want all the entries in database, that all the $name starts with "A",
> for example...
"SELECT * FROM table where column_name like 'A%'";

Not case-sensitive.
Mick

[Back to original message]