Page 1 of 1

Joker sign for search?

Posted: Tue Mar 12, 2013 3:19 pm
by tjnurmin
Script URL:
Version of script: 2.4
Hosting company:
URL of phpinfo.php:
URL of session_test.php:
What terms did you try when SEARCHING for a solution: search, joker, fulltext

Write your message below:
What is the joker sign for cutting search word in HESK? Asterisk didn't seem to work.

Re: Joker sign for search?

Posted: Wed Mar 13, 2013 9:00 pm
by Klemen
There is no "joker sign" because it uses fulltext mysql search. You will need to enter full words.

Re: Joker sign for search?

Posted: Sun Mar 17, 2013 9:34 pm
by tjnurmin
Yes, I noticed HESK uses FULLTEXT but in that case the wildcard operator should be asterisk, right?

http://dev.mysql.com/doc/refman/5.0/en/ ... olean.html

"The asterisk serves as the truncation (or wildcard) operator."

Asterisk does not seem to work, however.

Re: Joker sign for search?

Posted: Tue Mar 19, 2013 8:40 am
by Klemen
The asterisk (and some other operators) work in boolean mode only, so you would need to modify SQL statements to say for example:

Code: Select all

... MATCH(`subject`,`content`,`keywords`) AGAINST ('wildcard*' IN BOOLEAN MODE) ...
Note that the IN BOOLEAN MODE was added in the AGAINST statement.