MySQL by Letter

[®ed Eye Media - Richard Grove]

What would you guys say was the easiest and best way to get a list of users
details by letter.
Eg: getusers.php?l=A

Is there a MySQL command that I can use to get data by firstletter of a
specific field?
Or do I have to retrieve all and then loop through only showing relevant
results?

The second way seems a big waste of resources.
Many Thanks

Richard Grove

[®ed Eye Media - Richard Grove]

"®ed Eye Media - Richard Grove" <info@redeyemedia.co.uk> wrote in message
news:407124a2$0$95317$65c69314@mercury.nildram.net ...

> What would you guys say was the easiest and best way to get a list of

users

> details by letter.
> Eg: getusers.php?l=A
>
> Is there a MySQL command that I can use to get data by firstletter of a
> specific field?
> Or do I have to retrieve all and then loop through only showing relevant
> results?
>
> The second way seems a big waste of resources.
> Many Thanks
>

> Richard Grove
>
>

No Worries,
Sometime the easiest things are staring you straing in the face.
Richard Grove

[Jeppe Uhd]

®ed Eye Media - Richard Grove wrote:

> What would you guys say was the easiest and best way to get a list of
> users details by letter.
> Eg: getusers.php?l=A
>
> Is there a MySQL command that I can use to get data by firstletter of
> a specific field?

SELECT ... FROM ... WHERE specific_field LIKE 'a%'

--
MVH Jeppe Uhd - NX [url]http://nx.dk[/url]
Webhosting for nørder og andet godtfolk

[Chris Hope]

®ed Eye Media - Richard Grove wrote:

> What would you guys say was the easiest and best way to get a list of
> users details by letter.
> Eg: getusers.php?l=A
>
> Is there a MySQL command that I can use to get data by firstletter of a
> specific field?
> Or do I have to retrieve all and then loop through only showing relevant
> results?

Pretty standard sql:

select fieldname from tablename where fieldname like 'a%'

Chris

--
Chris Hope
The Electric Toolbox Ltd
[url]http://www.electrictoolbox.com/[/url]

[Unregistered]

this was very informative, however, I wonder if there's a way to find all the words that start with "any number or any special character" instead of a "letter". By example, your explanation would work in finding names of bands that start with "B", you click B and you get bands like "Blink 182" or "Bee Gees", but How can I find names that start with numbers, by clicking # and getting bands like "311", "1000 Maniacs".