partioning and wildcards

[Pascal Knapen]

Hi,

I have partitioned my table (tbl_ngrams) alphabetically using range partioning (on ngram_name). When performing simple query's like:

explain partitions select * from tbl_ngram where ngram_name like 'cancer%';

It seems that mysql uses all partitions of course this is not what I want.
When I perform without the wildcard:

select * from tbl_ngram where ngram_name = 'cancer';

Mysql does just fine. It uses only the partition that contains the words starting with the letter 'c'.

Now my question: Is there a way I can work around this problem or is it just me ;-). Most of the query's uses wildcards so ... Some help please



Edited 1 time(s). Last edit at 08/25/2006 02:01AM by Pascal Knapen.