Azu Posted September 12, 2007 Share Posted September 12, 2007 Hey guys When I use the widlcard in MySQL (%) it seems to act as an infinite amount of characters. Please tell me how to wildcard for just a SINGLE character.. So like (TES%) should match TEST but not TESTT? And also how can I change the default wildcard in MySQL so that it is * instead? I know I can replace * with % in PHP but this doesn't let me search for %.. I want to be able to use it in WHEREs as a normal character.. Quote Link to comment Share on other sites More sharing options...
Illusion Posted September 12, 2007 Share Posted September 12, 2007 like 'TES_' Quote Link to comment Share on other sites More sharing options...
Azu Posted September 15, 2007 Author Share Posted September 15, 2007 Thank you =) Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.