Simple MySQL query....!?

[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?

[Shrike]

There is a database forum for this, you will probably get a faster reply.

"SELECT stuff FROM table WHERE field LIKE 't%'";
"SELECT stuff FROM table WHERE SUBSTRING(field, 1) = 't'";

I'm not sure on the second version, might need some tweaking.