Hi Ben,
Ben Edwards wrote:
Can Mysql 4.20 use an index where like 'xxxxxx%' is in the where
clause against the column.
i.e. index table1(col1)
from table1
where table1.col1 like 'something%'
Yes, it can use an index on LIKE prefixes. Using a function such as LEFT(col1, 9) =
'something' will not work though.
You can always tell whether the index is used by examining EXPLAIN.
Cheers
Baron
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
