[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:  Database      |     Version:
 Severity:  normal        |  Resolution:
 Keywords:  dev-feedback  |     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 version 3.23.23 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

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 for MyISAM tables since version 3.23.23
 and for InnoDB tables since 5.6.

 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:5>
WordPress Trac <https://core.trac.wordpress.org/>
WordPress publishing platform