Previous Thread
Next Thread
Print Thread
Hop To
#261778 10/24/2018 8:25 AM
Joined: Jun 2006
Posts: 997
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 997
Likes: 24
Hi

I have see this topic a long time ago however I would like to ask a few things.

search example 1,

Searching for the word handle, the results shows handle but also handlebar and handlebars.
So if I just want handle to show up only how do I type the question?
I tried to type "handle" but same result came up.

2, another is the word Trump if someone search for that then words like trumpet can show up, how can I only search for trump?

Is there a way to exclude other words than the prefered?

also I use a 1.2 GB database with 68000 treads and 670000 posts which of the two options is best to use?
the UBB internal or MySQL Full text?





Last edited by Morgan; 10/24/2018 10:00 AM.

Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php
Joined: Jun 2006
Posts: 16,355
Likes: 125
UBB.threads Developer
UBB.threads Developer
Joined: Jun 2006
Posts: 16,355
Likes: 125
If you have a constant need of searching less than 3 letter words, I'd go UBB.threads Internal; the MySQL Full-Text Search uses the MySQL defaults which generally don't allow for searching 3 letters or less (see fine tuning below).
See UBBWiki: Search


You can find more information in changing this MySQL Server Setting at:
Change the full text index minimum ...ext index minimum word length with MySQL
12.9.6. Fine-Tuning MySQL Full-Text Search


You can also find several discussions on these forums by using the search function and looking for "MySQL Full-Text Search".


I am a Web Development Contractor, I do not work for UBBCentral. I have provided free User to User Support since the beginning of these support forums.
Do you need Forum Install or Upgrade Services?
Forums: A Gardeners Forum, Scouters World
UBB.threads: UBBWiki, UBB Styles, UBB.Sitemaps
Longtime Supporter & Resident Post-A-Holic
VNC Web Services: Code Modifications, Upgrades, Styling, Coding Services, Disaster Recovery, and more!
Joined: Dec 2003
Posts: 6,624
Likes: 84
Joined: Dec 2003
Posts: 6,624
Likes: 84
Don't know where the less that 3 characters came from which is true but not part of your question.

In your example you can use
Quote
"handle " or "trump "
Note the space at the end of the word
Now you will not get the highlighted text in the posts.
That is the way it always worked with using quotes.


Blue Man Group
There is no such thing as stupid questions. Just stupid answers
Joined: Jun 2006
Posts: 997
Likes: 24
Old Hand
Old Hand
Joined: Jun 2006
Posts: 997
Likes: 24
thanks


Morgan Johansson
BritBike Forum
https://www.britbike.com/forums/ubbthreads.php

Link Copied to Clipboard
ShoutChat
Comment Guidelines: Do post respectful and insightful comments. Don't flame, hate, spam.
Recent Topics
Another error
by Baldeagle - 10/07/2024 9:08 PM
Is this a cookie issue?
by Baldeagle - 10/05/2024 2:01 PM
Search button not there
by ehill - 10/02/2024 2:56 PM
Change the Order of the buttons in a post
by Unixspot - 09/19/2024 10:04 PM
How do I get rid of this?
by Baldeagle - 09/12/2024 6:30 PM
Who's Online Now
2 members (Ruben, Baldeagle), 842 guests, and 85 robots.
Key: Admin, Global Mod, Mod
Random Gallery Image
Latest Gallery Images
Los Angeles
Los Angeles
by isaac, August 6
3D Creations
3D Creations
by JAISP, December 30
Artistic structures
Artistic structures
by isaac, August 29
Stones
Stones
by isaac, August 19
Powered by UBB.threads™ PHP Forum Software 8.0.1
(Snapshot build 20240918)