Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 3 of 3
  1. #1
    Regular Coder
    Join Date
    Aug 2010
    Posts
    420
    Thanks
    18
    Thanked 2 Times in 2 Posts

    fulltext settings

    I've just started figuring out how to set up a php search that queries the database. I need to find how to change the default settings. I understand that the fulltext feature will only work on four or more characters. But it's a plant database and I have to change that to three so somebody can search for things like 'elm' or 'oak' or any other number of plants.

    Also, is there a way to set exceptions for shorter items? strangely enough there's a scientific name for a plant that is just "aa." I'm sure there's other instances I'd need to enter an exception?

    For reference, I'm working with MySQL 5.1 and using PHPMyAdmin
    thanks!

  2. #2
    Master Coder sunfighter's Avatar
    Join Date
    Jan 2011
    Location
    Washington
    Posts
    6,424
    Thanks
    30
    Thanked 878 Times in 876 Posts
    You need to post the search code.

  3. #3
    New to the CF scene
    Join Date
    Nov 2011
    Posts
    3
    Thanks
    0
    Thanked 1 Time in 1 Post
    You need to set the ft_min_word_len variable in my.ini file.

    [mysqld]
    ft_min_word_len=3
    (or "2" if you plan to search two-letter words)

    Detailed info is available here.

    Hope this helps.


 

Posting Permissions

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