Creating an exception in FULLTEXT searches

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • odysseyphotography
    #1

    Creating an exception in FULLTEXT searches

    Hi,

    I'm building a PHP site hosted on a commerical server (i.e. no access
    to MySQL system variables, only PHPMyAdmin).

    My client wants a FULLTEXT search on the site, but the most likely
    term people will be searching for is only two letters long.

    Is there a way of creating an exception without access to the MySQL
    system variables?

    Any help much appreciated.

    Thanks,

    OP

    Tags: None
    • ZeldorBlat
      #2
      Re: Creating an exception in FULLTEXT searches

      On Jun 28, 10:02 am, odysseyphotogra phy <i...@odysseyph otography.net>
      wrote:
      Hi,
      >
      I'm building a PHP site hosted on a commerical server (i.e. no access
      to MySQL system variables, only PHPMyAdmin).
      >
      My client wants a FULLTEXT search on the site, but the most likely
      term people will be searching for is only two letters long.
      >
      Is there a way of creating an exception without access to the MySQL
      system variables?
      >
      Any help much appreciated.
      >
      Thanks,
      >
      OP
      I'm not really sure what you mean by an "exception. " Some more
      details would help.

        Comment

        • odysseyphotography
          #3
          Re: Creating an exception in FULLTEXT searches

          Sorry, I should have been clearer.

          The site I am working on has a keyword (FULLTEXT) search, where users
          can enter search terms to search the databse with.

          The default settings for MySQL mean that any words less than four
          character long in any given 'search term' will be ignored.

          My problem is that users on my client's website are likely to be using
          very short search terms (2 characters). These will be ignored unless I
          can find of a work around.

          The site is hosted on a commercial server, so I am unable to access
          the MySQL settings.

          Thanks,

          OP

            Comment

            • shimmyshack
              #4
              Re: Creating an exception in FULLTEXT searches

              On Jun 28, 4:52 pm, odysseyphotogra phy <i...@odysseyph otography.net>
              wrote:
              Sorry, I should have been clearer.
              >
              The site I am working on has a keyword (FULLTEXT) search, where users
              can enter search terms to search the databse with.
              >
              The default settings for MySQL mean that any words less than four
              character long in any given 'search term' will be ignored.
              >
              My problem is that users on my client's website are likely to be using
              very short search terms (2 characters). These will be ignored unless I
              can find of a work around.
              >
              The site is hosted on a commercial server, so I am unable to access
              the MySQL settings.
              >
              Thanks,
              >
              OP
              its nasty cut you could have an IO filter, an array containing these
              short words that will bepushed to the database

              whereby any one of these special terms being stored in the database
              gets _make_me_longer _
              prepended to it, and any keyword term would therefore use this as
              well, when the data is extracted from the db, the string is removed,
              and the result set displayed.

              If they are words do you have to search for them using a keyword
              search, could you not use
              ' XX '
              where that word including spaces is 4 characters? Anyway thats all I
              got right now.

                Comment

                • odysseyphotography
                  #5
                  Re: Creating an exception in FULLTEXT searches

                  Thank you very much for that! I'll give it a go.

                  Best wishes,

                  OP

                    Comment

                    Previous template Next
                    Working...