Hi everbody.

How can I use LIKE in where clause with an index field; for example:

where whwmd215._index1 like ".*-BR.*"

Is it possible? I cannot compile...

Thanks!!

Hi everbody.

How can I use LIKE in where clause with an index field; for example:

where whwmd215._index1 like ".*-BR.*"

Is it possible? I cannot compile...

Thanks!!

try

where whwmd215._index1 like {".*-BR.*"}

(indexes values must be curly bracketed)

or where whwmd215.<field_name> like ".*-BR.*"

(using _indexX is useless if you use like, there is already a fulltable scan)