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? 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 Link to comment https://forums.phpfreaks.com/topic/235469-search-without-regex/#findComment-1210180 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.