cclaerhout
Well-known member
I'm just wondering, is there a reason why the Xenforo Search system use the following SQL command (full-text search) when performing a 'Search titles only':
Instead of:
Or even :
I'm asking this question because I've made a Chinese Words Index inside a forum. Most of the time a word is made of one or two characters. This word is inside the title of the post. So changing the sql command would be a solution to avoid the 'MySQL full text minimum word length' problem.
If you see no performance issue, I'm going to modify the search behaviour for one of my nodes.
Code:
WHERE MATCH(`blabla`, `blabla`, `blabla`) AGAINST ('mysearchword' IN BOOLEAN MODE)
Instead of:
Code:
WHERE `title` LIKE 'mysearchword'
Code:
WHERE `title` LIKE 'mysearchword%'
I'm asking this question because I've made a Chinese Words Index inside a forum. Most of the time a word is made of one or two characters. This word is inside the title of the post. So changing the sql command would be a solution to avoid the 'MySQL full text minimum word length' problem.
If you see no performance issue, I'm going to modify the search behaviour for one of my nodes.