php ===> mysql?

Question

i want to get the names from the database that they start with "a" or a certain char.
how can i do that?

no im using php and mysql

Answer 1

I would do it in the SQL query. The query would be similar to:
"SELECT * FROM table WHERE name LIKE 'a%'"

This would find all names that start with a in the field name in the table table. In SQL, a % is a wildcard, similar to *. Depending on the table setup, you may have to run a second query looking for A instead of a.

Answer 2

Use microsoft access