List:General Discussion« Previous MessageNext Message »
From:xian liu Date:February 8 2007 5:24am
Subject:improve performance for query statements with LIKE keyword
View as plain text  
Hi all,
 
Is there some way to improve performance for query statments with LIKE keyword ? like
this:
mysql> select id,name,title,description from books where description like
> '%some_strings%';

Note: Above "some_strings" is CJK(Chinese or Japanese or Korean).

I know MySQL cann't support CJK fulltext index type.

Thanks!

Best Regards, 
Liu Xian 

2007-02-07

@@@^_^@@@
 		
---------------------------------
 Mp3疯狂搜-新歌热歌高速下   
Thread
improve performance for query statements with LIKE keywordxian liu8 Feb