here we go:
explain select * from properties where reference like '%2332'
The above query cannot use the index on reference in either MyISAM or InnoDB case. However, with MyISAM it will hurt less because you are scanning a plain data file instead of a B-tree.
Suggestion for a workaround - add a column rev_reference with a key on it, update t1 set rev_reference = reverse(reference), and then do where rev_reference like '2332%';
-- Sasha Pachev Create online surveys at http://www.surveyz.com/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
