improve performance for query statements with LIKE keyword

[xian liu]

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疯狂搜-新歌热歌高速下