[rt-users] advanced search - customized like with wildcard

[Payam Poursaied]

Hi all

I'm looking for a way to search and find those tickets which their subject
starts with 'FAX'.

When I use "subject matches 'fax'" in advanced search, the search query is
something like 

..

main.Subject LIKE '%FAX%'

.

 

But I'm looking for a way to have a query with higher performance like

 

..

main.Subject LIKE 'FAX%'

.

 

Is there any way to make this query? 

 

 

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.bestpractical.com/pipermail/rt-users/attachments/20100316/3ba91619/attachment.htm>