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