[buddypress-trac] [BuddyPress] #5326: Break up multi-word group and member searches for better results

[buddypress-trac]

#5326: Break up multi-word group and member searches for better results
--------------------------+--------------------------
 Reporter:  boonebgorges  |      Owner:  boonebgorges
     Type:  enhancement   |     Status:  new
 Priority:  normal        |  Milestone:  2.0
Component:  Core          |    Version:
 Severity:  normal        |   Keywords:
--------------------------+--------------------------
 Currently, if you search "Awesome Group" in the Groups directory, it won't
 return "Awesome and Cool Group". We simply take the search terms and stick
 them into a LIKE clause.

 Making the search work really well is a hard task, but surely we can
 improve on this bit. Let's break up the search terms at word breaks, and
 do separate LIKE clauses connected by ANDs to get our results. Eg:

 {{{
 SELECT ... WHERE ( ( g.name LIKE '%Awesome%' OR g.description LIKE
 '%Awesome%' ) AND ( g.name LIKE '%Group%' OR g.description LIKE '%Group%'
 ) ) ...
 }}}

 And something similar for member/xprofile queries. See
 http://teleogistic.net/2014/01/a-less-finicky-buddypress-search/

 WordPress has a lot of good stuff, introduced in
 https://core.trac.wordpress.org/ticket/7394, to handle this kind of stuff.
 Sadly, most of it is marked protected and is organized in such a way that
 it won't really be usable for our purposes. We could try to
 compartmentalize it and pass patches upstream, or simply build our own
 modular versions based on it.

 I think we could do something pretty minimal with high impact with not too
 much work. So I'm putting this tentatively in 2.0.

--
Ticket URL: <https://buddypress.trac.wordpress.org/ticket/5326>
BuddyPress <http://buddypress.org/>
BuddyPress