Query finding the term using the first letter...

[j_miguel_y]

I want to find a term in my whole table starting with a specific letter.

SELECT * FROM myTABLE..............?

Anyone know this easy question?

[devinemke]

to find all records starting the letter "A"

SELECT * FROM table WHERE field REGEXP "^A"