MySQL support text search with the help of LIKE operator and Regular expressions. However, it is not a full-fledged text search as it does not provide relevant ranking of search results, results for complex queries and is not performance oriented. To overcome these limitations, MySQL has come up with a new feature called full-text search. It is available only for InnoDb and MyISAM engines after version 5.6. Full-text search uses a sophisticated algorithm to eliminate drawbacks. It has the following features: Simplicity: You use SQL queries to use the full-text search. Fully dynamic index: MySQL [...]
Posted on: Fri, 05 Dec 2014 10:39:50 +0000
Trending Topics
Recently Viewed Topics
© 2015