You may want to check the Sphinx search engine
http://sphinxsearch.com/
It took me about one day to set it up and learn how to use, but it does really good job with sorting by relevancy and grammar stemming. Also it is faster than fulltext search for big data sets thanks to indexing.
Related Posts:
- What SQL Query to do a simple find and replace
- Optimize Multiple Taxonomy Term MySQL Query?
- Search and replace text across all posts
- Custom Query to search through categories
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- sort search results by custom fields using dropdown
- Searching With Apostrophe
- Ideas how to search & replace post_content when string contains a newline?
- How to manage a particular “order by” for get_search_query()?
- (WP List Table) How to sort by SKU and Custom Fields?
- PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
- How to make MySQL search queries with quotes
- MySQL error 2006: mysql server has gone away
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- what does “/index.php?admin/admin_dashboard” in my url mean
- How to join two tables by multiple columns in SQL?
- How to get size of mysql database?
- MySQL Error 1093 – Can’t specify target table for update in FROM clause
- mysqladmin: connect to server at ‘localhost’ failed
- mysql update multiple columns with same now()
- Usage of MySQL’s “IF EXISTS”
- Generating a random & unique 8 character string using MySQL
- MySQL > Table doesn’t exist. But it does (or it should)
- Getting java.sql.SQLException: Operation not allowed after ResultSet closed
- How to create a foreign key in phpmyadmin
- Can’t create test file lower test start server mysql
- MySQL delete multiple rows in one query conditions unique to each row
- SQLSTATE[HY000] [2002] php_network_getaddresses: getaddrinfo failed: Name or service not known
- CAST to DECIMAL in MySQL
- How do you properly prepare a %LIKE% SQL statement?
- How to correctly submit a search form and display the result in an independent page
- Sort posts by category name and title
- SQL query to update post_date (one post = one single date & time)
- Updating User Meta with SQL Query
- wpdb prepare syntax
- How to run this SQL query of wp_terms database
- WooCommerce – Query for ordered products
- search through post-type attachments titles
- How to find if a post with custom_field == X exists?
- WP database error for comments_popup_link()
- How to change post format from Aside to Image for all posts?
- Query WordPress database by registered date and role
- Inserting Hundreds of Thousands of Posts at Once
- wp_admin edit.php slow with lots of queries
- How to add and SQL query of posts only published
- Slow Mysql Queries
- can database and media folder be moved to a different drive?
- Sorting posts alphabetical that have single digits
- Select Multiple meta_value from WP DB; Single Query
- My SQL function to change user_name
- writing inner join in wpdb
- CRUD operations using WordPress database API
- Tags to Post-ID mysql query. Tag Search
- Why is variable not working on custom sql query using wpdb?
- How to get data from WordPress site sql file
- Unknown collation when I import a dump from an existing site into a development database?
- PHP script can’t connect to Database on port 3307
- WordPress with php5-fpm and nginx
- how would I create a custom query to get all users, and a related post based on a postmeta field?
- Slow queries constantly getting stuck on WordPress database of ~100,000 posts
- How to translate this mySQL query to $wpdb query
- $wpdb to insert html form information
- Proper usage of $wpdb->update()?
- Separate DB by yearly archive of WordPress
- What should a WordPress developer know about MySQL? [closed]
- Copyright: Get first and last date of post type
- Can’t seem to do combined query AND sort?
- Update MySQL query so that it functions again
- How to reset usual $query on search page to push custom $wpdb query there?
- Get a list of posts by specific category
- How to query two meta fields and display results between them
- Query posts by custom taxonomy and sort by post_modified
- WordPress $wpdb get posts from category and sort by custom meta
- Sorting search results with custom dropdown
- Query the WordPress database to get data together with replaced information
- Array Formation Issue
- Migration problems with mysql: Operation not allowed when innodb_forced_recovery > 0 [closed]
- Updating with $qpdb->query() always returns 0 rows affected
- Build A Custom SQL Query for WordPress Search
- Trying to get all links in my posts
- when using $wpdb sudden connection rejection without changing anything. Access denied, with errors from repair tool
- edit_user_created_user hook – using to update Groups
- How to filter result set in custom metaboxes?
- Trouble migrating custom post types from non-wordpress cms
- Improving performance of SQL sub-queries in WordPress
- New custom post type entries are not sorted correctly in admin using pre_get_posts
- Saving custom term value to the database in new table
- Run search query again without pagination gives no results?
- MYSQL Join on meta key value?
- Parsing External Table Arguments
- Form Data Causes “Page Not Found”
- Complicated MySQL Query
- problem with quotes on new post
- SQL Query to get post_id from wp_posts and and meta_key(s) from wp_postmeta
- Sort Search Results in Order of/by Character @ count (9) of post(s) title. (Ocean-WP theme)
- Sort Posts Alphabetically Based on Specific Category (Divi)
- Initialization of table in database using ‘CREATE … IF NOT EXISTS’
- mysqldump throws: Unknown table ‘COLUMN_STATISTICS’ in information_schema (1109)
- Batch Replace URLs in WordPress Database