MySQL Forums
Forum List  »  Optimizer & Parser

otimize search with wildcar "%" ?
Posted by: edson fernando
Date: April 07, 2007 12:02AM

how to optimize this type of search in table?

in search with wildcard % is not possible to use index, the table has 1 million registers

how to make to stop the research after joined in the maximum 30 registers? how to optimize this type of search?

SELECT idclient,name,product FROM "tbl_clients" WHERE clientname LIKE '%".$keyword."%';

Options: ReplyQuote

Written By
otimize search with wildcar "%" ?
April 07, 2007 12:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.