The Arcive of Official vBulletin Modifications Site.It is not a VB3 engine, just a parsed copy! |
|
#1
|
|||
|
|||
Need help with Boolean Search Problems...
So I am using the following code for my boolean search...
Code:
$results = $vbulletin->db->query_first(" SELECT media FROM " . TABLE_PREFIX . "media WHERE MATCH (title, description) AGAINST ('".$keyword."' IN BOOLEAN MODE) "); 1 - searching for words 3 letters and less return no results. My researching is telling me this is because of a default setting for fulltext searching in mysql that requires a minimum of 4 characters in a search and has to be changed manually... so this is not the real issue... 2 - having trouble finding partial matches for searching. Lets say I have a media with the title "Cassandra VS Cervantes". Searching for "Cassandra" will pull this result up without any issues; however searching for "Cass" or "sandra" will not return this entry in the result. Is there any way to get boolean search to find partial matches? --------------- Added [DATE]1280272330[/DATE] at [TIME]1280272330[/TIME] --------------- So I went back to my old search... its not boolean, but I have another issue... Code:
$results = $vbulletin->db->query_first(" SELECT media FROM " . TABLE_PREFIX . "media WHERE description LIKE '%".$keyword."%' OR title LIKE '%".$keyword."%' "); |
Thread Tools | |
Display Modes | |
|
|
X vBulletin 3.8.12 by vBS Debug Information | |
---|---|
|
|
More Information | |
Template Usage:
Phrase Groups Available:
|
Included Files:
Hooks Called:
|