How to search submission by exact phrase [resolved]

[nomad]

Hi,
is there any way how to search submissions by exact phrase?

I have tested ft_search_submissions function, but it does not distinguishs capital and small characters also all substings are find ("aab" works like "aab*").

I need to search records by exact unique generated "voucher" value to let users use a discount coupon.

Thanks for any idea.

[Ben]

Hi Nomad,

Hmm... all search strings are automatically wrapped in MySQL wildcard characters ("%") to return anything that contains that string; this can't be undone, or overridden by a module, unfortunately.

Sorry, I don't have any great suggestions for you...

- Ben

[nomad]

Hi Nomad,

Hmm... all search strings are automatically wrapped in MySQL wildcard characters ("%") to return anything that contains that string; this can't be undone, or overridden by a module, unfortunately.

Sorry, I don't have any great suggestions for you...

- Ben

Thanks for replay, Ben,
I will add a test of the length of search string to avoid wildcards + will extend lenght of vouchers to compensate capital and lower-case substitution (maybe little bit paranoid :-)).

Merry Christmas.