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%' Regards, Ben -- Ben Edwards - Bristol, UK If you have a problem emailing me use http://www.gurtlush.org.uk/profiles.php?uid=4 (email address this email is sent from may be defunct) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]