Selecting words by letter from a db

[Zimm]

I'm trying to grab information from a database according to the first letter of the word. So if I wanted to grab all the words that began with A, it would only grab those words.

I went looking through php.net to see if there was a function that allowed me to count over 1 from the beginning of a word, then see if it is the letter I was looking for, but didn't come up with anything, or I went over it.

So I tried selecting from a mysql database words that began with the letter a by:

$bringdata = mysql_query("SELECT id,valuea FROM test WHERE valuea='A*'");
while($data=mysql_fetch_row($bringdata)){
echo $data[1];
}

But that didn't work.

Is there a way one can accomplish this?

[TGixer]

select * from Table where name_field LIKE 'a%'

[malbera]

$bringdata = mysql_query("SELECT id,valuea FROM test WHERE valuea LIKE 'A%' "); 

this should work

[largo]

$field = "a";

$query = "SELECT DISTINCT UCASE(SUBSTRING($field, 1, 1)) AS letter FROM table ORDER BY letter";

[Zimm]

Cool,

thanks!

now the script words 😃