HELP: How to list results via alphabet

[Anon]

Hi,

I'm reletivly new to php, and i'd like to display results from a mySQL database based on a query which only looks at the first charecter in a field and checks to see if thats the same as the passed argument.

So for example I want to search for items which has an 'A' as its first letter etc.

I'd be grateful if someone knows if this is possible.

[Anon]

Use the LIKE operator:

$letter = 'A';

$query = "SELECT field_name FROM tbl_name WHERE field_name LIKE '$letter%'";

// then send the query, etc...

Diego

[Anon]

Thanks

But if the field has a value of 'American' and i want to return fields that have an 'A' as its first charecter, how could I do that.

[Anon]

use substr() to get the first character...

Diego