The following warnings occurred: | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Warning [2] Undefined array key "avatartype" - Line: 783 - File: global.php PHP 8.1.31 (Linux)
|
![]() |
How to search submission by exact phrase [resolved] - Printable Version +- Form Tools (https://forums.formtools.org) +-- Forum: Form Tools (https://forums.formtools.org/forumdisplay.php?fid=1) +--- Forum: General Discussion (https://forums.formtools.org/forumdisplay.php?fid=5) +--- Thread: How to search submission by exact phrase [resolved] (/showthread.php?tid=404) |
How to search submission by exact phrase [resolved] - nomad - Dec 21st, 2009 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. RE: How to search submission by exact phrase - Ben - Dec 23rd, 2009 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 RE: How to search submission by exact phrase - nomad - Dec 23rd, 2009 (Dec 23rd, 2009, 12:54 PM)Ben Wrote: Hi Nomad, 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. |