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]

Reply via email to