[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       |  Resolution:
 Keywords:               |     Focuses:
-------------------------+------------------------------
Description changed by zieladam:

Old description:

> 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

New description:

 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 @TimothyBlynJacobs 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#comment:1>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform