[wp-trac] [WordPress Trac] #14722: use MATCH/AGAINST instead of LIKE when querying for matching terms posts

[WordPress Trac]

#14722: use MATCH/AGAINST instead of LIKE when querying for matching terms posts
-------------------------+--------------------------------------------------
 Reporter:  pgentoo      |       Owner:                 
     Type:  enhancement  |      Status:  new            
 Priority:  normal       |   Milestone:  Awaiting Review
Component:  Performance  |     Version:  3.0.1          
 Severity:  normal       |    Keywords:                 
-------------------------+--------------------------------------------------
Changes (by scribu):

  * keywords:  needs-patch =>
  * milestone:  3.1 => Awaiting Review


Comment:

 Yeah, I've done something similar on my localhost, but got an SQL error
 because...

 There is no FULLTEXT index on any column in any table in the WordPress
 schema. The one you have was probably added by a plugin.

 Speaking of which, it's pretty easy to change the generated query from a
 plugin, using the 'posts_search' filter.

-- 
Ticket URL: <http://core.trac.wordpress.org/ticket/14722#comment:4>
WordPress Trac <http://core.trac.wordpress.org/>
WordPress blogging software