On 2012-06-20, Sam Z J <sammyjiang721(at)gmail(dot)com> wrote:
> --0016e6d999db24c4c704c2ea7a97
> Content-Type: text/plain; charset=ISO-8859-1
>
> Hi all
>
> I'm curious how is wildcards at both ends implemented, e.g. LIKE '%str%'
> How efficient is it if that's the only search criteria against a large
> table? how much does indexing the column help
fulltextsearch can be abused with a custom lexer that fragments the string in every possible
way and that can be matched against, but not using LIKE.
Works OK on tables with tens of thaousands of rows haven't tried it on
larger rows.
--
⚂⚃ 100% natural