Quote from the "How MySQL Uses Indexes" document: ################ MySQL 4.0 does another optimisation on LIKE. If you use ... LIKE "%string%" and string is longer than 3 characters, MySQL will use the Turbo Boyer-Moore algorithm to initialise the pattern for the string and then use this pattern to perform the search quicker. ################
Does this optimisation depend on the existence of an index on that column, or is it used even without an index? Either way, how big is the speed improvement? -- Florin Andrei "Cryptophiles had been so enraptured by the possibilities of uncrackable ciphers that they forgot they were living in a world in which people can't program VCRs." - Bruce Schneier --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <mysql-unsubscribe-##L=##[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
