DBAsupport.com Forums - Powered by vBulletin
Results 1 to 10 of 10

Thread: 3 letter search

Hybrid View

  1. #1
    Join Date
    Oct 2000
    Location
    Germany
    Posts
    1,185

    3 letter search

    The inability to search on words with less than 4 letters is frustrating.

    I can no longer use MTS, OID, OCP and OEM as search criteria. Many useful posts do not refer to the fully typed names represented by these acronyms and will not show up in the return set. It limits the usability severely.
    David Knight
    OCP DBA 8i, 9i, 10g

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    agree

  3. #3
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    4,166
    Because of this feature we can't directly search for the following: JDK, JRE, 9i, 8i, SQL, 9.2, etc. Please allow us to search by 2 or more characters.

  4. #4
    Join Date
    Sep 2001
    Location
    Düsseldorf, Germany.
    Posts
    588
    I support

  5. #5
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525

    Thumbs up

    Totally agree
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  6. #6
    Join Date
    Nov 2000
    Posts
    416
    Is it an enhancment to the site?? It's rediculous. It doesn't let us to search whatever we want. The OLD Site layout was better.

    Moderators please answer. How can I search for a word less than four char??
    An ounce of prevention is worth a pound of cure

  7. #7
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    Originally posted by farrokhp
    Is it an enhancment to the site?? It's rediculous. It doesn't let us to search whatever we want. The OLD Site layout was better.

    Moderators please answer. How can I search for a word less than four char??
    you cannot?

    simple as that

  8. #8
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    Originally posted by pando
    you cannot?

    simple as that
    You can fudge it by searching for *RAC* or *9i*

    But it would still be nice to beable to perform a direct search

    Regards
    Jim
    Oracle Certified Professional
    "Build your reputation by helping other people build theirs."

    "Sarcasm may be the lowest form of wit but its still funny"

    Click HERE to vist my website!

  9. #9
    Join Date
    Nov 2000
    Posts
    416
    I really just DON'T understand why you put this restriction to the search ability of the site. It's just doesn't make any sense what so ever. Can you give me just ONE good reason for this so-called enhancment!
    An ounce of prevention is worth a pound of cure

  10. #10
    Join Date
    Dec 2002
    Posts
    0
    As I understand it, it's a "feature" of MySQL. As of Version 3.23.23, MySQL has support for full-text indexing and searching. FULLTEXT indexes are most often used to search natural language text, such as through newspaper articles, web page contents and so on. For this reason MySQL has added a number of features to assist this kind of searching. MySQL does not index any words less than or equal to 3 characters in length, nor does it index any words that appear in more than 50% of the rows.
    ____________________
    Thanks,
    Linda

    http://dbasupport.com/
    http://databasejournal.com/



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width