Torrodon Posted May 4, 2011 Share Posted May 4, 2011 If I have something like select * from `table` where `desc` like '%test.com%' Is there a way to search for exact string "test.com", not the pattern "test.com", so the dot is dot and not any char and so? Quote Link to comment https://forums.phpfreaks.com/topic/235469-search-without-regex/ Share on other sites More sharing options...
mikosiko Posted May 4, 2011 Share Posted May 4, 2011 drop the %'s and use the escape "\" default character before the dot or define your own escape character using ESCAPE Quote Link to comment https://forums.phpfreaks.com/topic/235469-search-without-regex/#findComment-1210180 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.