all started with letter a

[ryansdistrict]

hey folks

how can i write a query from a mysql database that will fetch from the database all the names of members who got the first letter of their names a certain letter forexample letter a

and how to have the non letters in 1 query

 

i though of doing something like SELECT col FROM table WHERE col LIKE 'v%'

 

[fenway]

You mean like:

 

WHERE first_name LIKE 'a%'

 

?

[ryansdistrict]

[i am making babys name script where it shows babies names details origin meaning and such details]

 

yes what about the numbers and other characters

 

 

also how can i make the index page where the links located for each letter

any idea ?

 

another question in the database their is countries for the origin of each name

How can i generate a query for each country name in an easy way in the and index it in the index page

 

 

 

[rhodesa]

Try for letters:

WHERE UPPER(first_name) REGEXP '^A'

and for non-letters:

WHERE UPPER(first_name) REGEXP '^[^A-Z]'

[fenway]

Assuming you're working with case-insensitive collations (the default), UPPER() shouldn't matter.