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
Navigation:
[Reply to this message]
|