Jump to content

Archived

This topic is now archived and is closed to further replies.

Tandem

Un-precise mysql querying

Recommended Posts


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...

Share this post


Link to post
Share on other sites
[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

Share this post


Link to post
Share on other sites

×

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.