Full text search: Difference between revisions
Jump to navigation
Jump to search
Created page with "Full text searching in web applications means searching documents which have content and some metadata (usually at least a title). Examples include: * Blog posts * RSS feed items" |
No edit summary |
||
| Line 3: | Line 3: | ||
* Blog posts | * Blog posts | ||
* RSS feed items | * RSS feed items | ||
== MySQL == | |||
MySQL and MariaDB have the MATCH operator, which can perform basic full text searches. | |||
Although older versions of MySQL only supported full text indexes on MyISAM tables, this is no longer the case and InnoDB tables can (and should!) be used. | |||
== PostgreSQL == | |||
== Apache Solr == | |||
Revision as of 08:11, 6 January 2022
Full text searching in web applications means searching documents which have content and some metadata (usually at least a title). Examples include:
- Blog posts
- RSS feed items
MySQL
MySQL and MariaDB have the MATCH operator, which can perform basic full text searches.
Although older versions of MySQL only supported full text indexes on MyISAM tables, this is no longer the case and InnoDB tables can (and should!) be used.