MySQL supports text searching by using the LIKE statement and regular expression. However, when the text column is large and the number of rows in a table is increased, using those methods has limitations: Performance: MySQL has to scan the whole table to find the exact text based on pattern in the LIKE statement or pattern in the regular expressions. Flexible search: with the LIKE statement and regular expression ... Read More »
You are here: Home > Tag Archives: full text search