Un-precise mysql querying

[Tandem]

SELECT * FROM EXAMPLE WHERE USER='T';

I want the search to return every 'USER' that begins with a T. I'm pretty sure i have to add a character after the T but can't remember which, and the syntax for doing it.

I read somewhere about how to do this a while back but forgot how, and my google searches are returning irrelevant results.

Thanks for any help...

[JaGeK]

[quote author=Tandem link=topic=101500.msg401791#msg401791 date=1153601763]I want the search to return every 'USER' that begins with a T. I'm pretty sure i have to add a character after the T but can't remember which, and the syntax for doing it.[/quote]
You're probably searching for LIKE:

-> http://www.w3schools.com/sql/sql_where.asp

[Tandem]

Thanks, that was what i was looking for :)