Search by first letter of name or title?

[Vigilante]

Okay, I have a script which takes an HTTP_GET argument which is a letter. I have 26 links and that's where what to do next isn't so obvious.

I want to list all results where a mysql field named "name" starts with any letter. I've seen these around and I would guess there is a mysql function which does what I'm looking for. Could someone tell me how to do this?

[su1d]

SELECT * FROM table_name WHERE name LIKE "c%"
will select everything starting with letter c or C (if name field is not binary)

[bastien]

$sql = "select * from tablename where name like."$_GET['value']."%";

which says to take all items in the field name where the first letter value and anything after that is chosen

hth

[svnfightsvn]

try a query using the LIKE operator:

SELECT * FROM mysql_table WHERE name LIKE '$letter%'

...the % represents the wildcard character meaning anything after this....i don't know what is is for mysql