Fulltext searches

The segment editor forces fulltable scans via the ‘contains’ rule. The resulting sql command searches via

like concat('%', 'phrase', '%')

. Is it possible to add something to force a search from the beginning, lets say


will generate a

 like concat('phrase', '%')

to reduce fulltable scans and offer the oportunity to create an index accordingly? Looking into nearer future, MariaDB or Mysql 5.6.x are assisting fulltext searches via the sphinx engine. Wouldn’t that be a performance gainer for this ‘like’ searches?

I guess we can summarize with “Add ‘Starts with’” operator? this would be OK but not high impact IMO…