how to grab first letter of name

[pixeltrace]

hi,

 

i have a pagination that has the alphabet buttons also.

 

how to i set the query so that when i click the letter

it will return the list wherein all names starts with that letter

 

let say,

i click letter "A"

 

in the return list,

 

all names starting at A will be listed.

 

hope you could help me with this.

 

thanks!

[jitesh]

SELECT * FROM `table` WHERE `Keyword` Like 'A%'

[tibberous]

select * from tablename where word like 'A%'

[Daniel0]

select * from tablename where word like 'A%'

 

That's exactly what jitesh just said...