Joker sign for search?

[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.

[Klemen]

There is no "joker sign" because it uses fulltext mysql search. You will need to enter full words.

[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.

[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.