On Wed, 2 Apr 2003, Shamit Verma wrote: > The replay on the webpage says that: > "Nope. That would be a really slow search since mysql cant use any > indexes and a table scan would be the only way to find it." > > Then even "LIKE" operator should suffer from the same performance drawback, > how does LIKE operator work with indexes?
exactly. LIKE '%something' will not use indexes but LIKE 'some%' will. Thomas Spahni -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]