SharkBait Posted July 26, 2010 Share Posted July 26, 2010 Am I right to assume that when you use wildcards (%) in a SELECT WHERE clause, that it will only match based on order of given terms? IE: SELECT * FROM name LIKE ('%this%that%') Will only match: 'something like this is like that', or ' this thing is that thing' etc? Where as SELECT * FROM name LIKE ('%that%this%') will not match any of the above, since the order of terms are reversed? I would assume that FULLTEXT search would be the ideal thing to use, right? Since the terms being looked up can be in no particular order? Quote Link to comment https://forums.phpfreaks.com/topic/208935-select-where-clause/ Share on other sites More sharing options...
Alex Posted July 26, 2010 Share Posted July 26, 2010 Yes. Quote Link to comment https://forums.phpfreaks.com/topic/208935-select-where-clause/#findComment-1091368 Share on other sites More sharing options...
SharkBait Posted July 26, 2010 Author Share Posted July 26, 2010 Cool thanks Quote Link to comment https://forums.phpfreaks.com/topic/208935-select-where-clause/#findComment-1091481 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.