[wp-trac] [WordPress Trac] #51769: Full-text search support

[WordPress Trac]

#51769: Full-text search support
-------------------------+-----------------------------
 Reporter:  zieladam     |      Owner:  (none)
     Type:  enhancement  |     Status:  new
 Priority:  normal       |  Milestone:  Awaiting Review
Component:  General      |    Version:
 Severity:  normal       |   Keywords:
  Focuses:               |
-------------------------+-----------------------------
 Let's talk about first-class fulltext search support in WP core. Is there
 any reason not to support FULLTEXT search in WordPress core for newer
 MySQL versions with the current search mechanism serving as a fallback for
 older MySQL versions?

 MySQL supports FULLTEXT indexes since at least 5.1 for MyISAM tables.
 Since MySQL 5.6, it also supports FULLTEXT indexes for InnoDB tables.

 As @timothybjacobs noted, WordPress supports versions back to MySQL 5.0:

 https://github.com/WordPress/wordpress-develop/blob/master/src/wp-
 includes/version.php
 src/wp-includes/version.php

 As @desrosj noted:
 * The recommended versions are MySQL >= 5.6/MariaDB >= 10.1 as per
 https://wordpress.org/download/.
 * According to the WordPress stats page, a considerable amount of sites
 use MySQL 5.5 (35%), and some still use 5.1/5,0. Raising support to >= 5.6
 is not really an option.

 The last discussion about that feature I found was from 10 years ago so
 maybe it's good time to re-evaluate:

 https://core.trac.wordpress.org/ticket/14722

-- 
Ticket URL: <https://core.trac.wordpress.org/ticket/51769>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform