Brandon Posted December 9, 2004 Share Posted December 9, 2004 I would like to see the 3 letter-word + search thing taken away. such as last night i was searching for the BMW with the soccer ball fallen on top of it thread... BMW wasnt long enough. or someone might search CDR, or even having ONE word under 3 letters gives you an error.... just annoying if u ask me Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/ Share on other sites More sharing options...
IceDogg Posted December 9, 2004 Share Posted December 9, 2004 That would be nice, with all the 3 letter tech terms out there. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585071945 Share on other sites More sharing options...
Old Man Pickle Posted December 9, 2004 Share Posted December 9, 2004 ... or 'MSN' as happened to me 2 days ago. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585071959 Share on other sites More sharing options...
nicholasadams Posted December 9, 2004 Share Posted December 9, 2004 I don't think you can, as MySQL has a set minimum of 3 characters for fulltext searching. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585071971 Share on other sites More sharing options...
Frank Posted December 9, 2004 Share Posted December 9, 2004 Sometimes adding a * after the three letter term will help, but I haven't been 100% successful with this yet. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072016 Share on other sites More sharing options...
+dave164 Subscriber¹ Posted December 9, 2004 Subscriber¹ Share Posted December 9, 2004 yeh and if ur searching Danger Den, it won't let you, as it contains 'Den' in it Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072029 Share on other sites More sharing options...
+unabatedshagie Subscriber¹ Posted December 9, 2004 Subscriber¹ Share Posted December 9, 2004 Joel posted this a few days ago (I think), search for small words using google open google and in the search box type (search keyword) site:www.neowin.net eg CDR site:neowin.net would give you this Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072160 Share on other sites More sharing options...
sjgore Posted December 9, 2004 Share Posted December 9, 2004 I agree, you can't even do a search for "HL2" or "MP3"! Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072162 Share on other sites More sharing options...
john smith 1924 Veteran Posted December 9, 2004 Veteran Share Posted December 9, 2004 the google search is the best way to do it i'm afraid. The 3 chars search min restriction is something that's hard coded either at IVB level or MySQL (guessing IVB). Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072252 Share on other sites More sharing options...
IceDogg Posted December 9, 2004 Share Posted December 9, 2004 Joel posted this a few days ago (I think),search for small words using google open google and in the search box type (search keyword) site:www.neowin.net eg CDR site:neowin.net would give you this 585072160[/snapback] Is there a way to setup a keyword search bookmark for this in FireFox by any chance? anyone? Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072305 Share on other sites More sharing options...
Steven Posted December 9, 2004 Share Posted December 9, 2004 the google search is the best way to do it i'm afraid. The 3 chars search min restriction is something that's hard coded either at IVB level or MySQL (guessing IVB). 585072252[/snapback] It's SQL... if you search for this you'll find another thread about this. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072877 Share on other sites More sharing options...
Brandon Posted December 9, 2004 Author Share Posted December 9, 2004 the google search is the best way to do it i'm afraid. The 3 chars search min restriction is something that's hard coded either at IVB level or MySQL (guessing IVB). 585072252[/snapback] in that case, could there be a link on the site which has search using google (other sites have it) so you type in like MSN and it automatically fills in the search only neowin.net thing in the search... like the knoppiz forums have this Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072880 Share on other sites More sharing options...
Joel Posted December 9, 2004 Share Posted December 9, 2004 It's SQL... if you search for this you'll find another thread about this. 585072877[/snapback] No no, you will find MANY other threads for this. :p https://www.neowin.net/forum/index.php?show...l=search+letter https://www.neowin.net/forum/index.php?show...l=search+letter https://www.neowin.net/forum/index.php?show...hl=search+limit https://www.neowin.net/forum/index.php?show...1&st=&p=entry Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072925 Share on other sites More sharing options...
JMann Veteran Posted December 9, 2004 Veteran Share Posted December 9, 2004 No, this has been discussed in the Subscriber Forum, secret reason why though. :ninja: It cannot be done due to what Magoo said, it's hard coded into the mySQL I believe, and is unchangable, and I think its something to do with Search strings have to be longer for mySQL to recognise and locate information from the DB. JMann Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072946 Share on other sites More sharing options...
Steven Posted December 9, 2004 Share Posted December 9, 2004 No no, you will find MANY other threads for this. :phttps://www.neowin.net/forum/index.php?show...l=search+letter https://www.neowin.net/forum/index.php?show...l=search+letter https://www.neowin.net/forum/index.php?show...hl=search+limit https://www.neowin.net/forum/index.php?show...1&st=&p=entry 585072925[/snapback] :rofl: :laugh: Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585072966 Share on other sites More sharing options...
sfalcon Posted December 12, 2004 Share Posted December 12, 2004 If it's hardcoded into MySQL, why is there this option in the Admin Control Panel? Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090285 Share on other sites More sharing options...
emo Posted December 12, 2004 Share Posted December 12, 2004 yea i cant even search for the word "emo" Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090365 Share on other sites More sharing options...
KC Posted December 12, 2004 Share Posted December 12, 2004 I would cause massive server loads you do relieze that right? Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090436 Share on other sites More sharing options...
PeterClark Posted December 12, 2004 Share Posted December 12, 2004 I would cause massive server loads you do relieze that right? 585090436[/snapback] why? Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090473 Share on other sites More sharing options...
sfalcon Posted December 12, 2004 Share Posted December 12, 2004 I would cause massive server loads you do relieze that right? 585090436[/snapback] Obviously, the point is whether or not it is actually possible. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090478 Share on other sites More sharing options...
Joel Posted December 12, 2004 Share Posted December 12, 2004 If it's hardcoded into MySQL, why is there this option in the Admin Control Panel? 585090285[/snapback] mySQL is not the only DB program IPB runs on. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090637 Share on other sites More sharing options...
JMann Veteran Posted December 12, 2004 Veteran Share Posted December 12, 2004 mySQL is not the only DB program IPB runs on. 585090637[/snapback] (Y) And it would bring on lots of slower times, it annoys me sometimes, but just improve your search. Also, if the search strings typed in where long or was very popular, it would slow down the server loads, because it has to shift through so much, I believe. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585090722 Share on other sites More sharing options...
Tim Dorr Veteran Posted December 13, 2004 Veteran Share Posted December 13, 2004 If it's hardcoded into MySQL, why is there this option in the Admin Control Panel? 585090285[/snapback] It says right there that it doesn't apply for FULLTEXT searching. We would have to change MySQL's configuration, drop and re-add the post table index for FULLTEXT to support lower than 4 letters. I need to upgrade Neowin to MySQL 4.1 and do this anyways, but the index size could be massive (and therefore slower)... Edit: Well, 4.1 is installed. I'l have to try the reindex later tonight. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585092574 Share on other sites More sharing options...
calidude Posted December 13, 2004 Share Posted December 13, 2004 Is that why I keep getting these page cannot be displayed errors? :unsure: Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585092692 Share on other sites More sharing options...
Tim Dorr Veteran Posted December 13, 2004 Veteran Share Posted December 13, 2004 Yep, just working on the site. 3 letter searches are now the minimum. We'll see how that goes. Link to comment https://www.neowin.net/forum/topic/255037-suggestion-remove-search-3-letter-word/#findComment-585092786 Share on other sites More sharing options...
Recommended Posts