ataria Posted December 2, 2006 Share Posted December 2, 2006 WHERE `x`='x'and..WHERE `x` LIKE 'x'what is the difference? Link to comment https://forums.phpfreaks.com/topic/29235-like-and-equal/ Share on other sites More sharing options...
wildteen88 Posted December 2, 2006 Share Posted December 2, 2006 This is not a php question but an SQL syntax question. I'll this to MySQL board in a secHowever to answer you question. WHERE `x`='x' checks for exact matches, such say x is apple it look for exact matches in the database for any rows that has apple as its value, where as WHERE `x` LIKE 'x' does not check for exact matches but close matches, so apples and apple are matches. Link to comment https://forums.phpfreaks.com/topic/29235-like-and-equal/#findComment-134019 Share on other sites More sharing options...
keeB Posted December 2, 2006 Share Posted December 2, 2006 You can use like with wildcards, ala [code=php:0]where `x` like '%ab%'[/code]That will pull any field in X that contains ab at all. Link to comment https://forums.phpfreaks.com/topic/29235-like-and-equal/#findComment-134020 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.