I have one question about the alphabetical search, I have written a SQL
"SELECT * FROM name where firstname like 'A%'" to show all the name which are start from A.
If I want to search from A to Z, do I need to write 26 SQL statements to do that or do I have another better methods to do that?
That mean when i click on A, it will search all the records that firstname starting from A, when i click on D, it will show all the records that the firstname is only start from D.
Anyone can help me to solve this problem.
Thx!