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
    419
    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
    Senior Coder
    Join Date
    Jan 2011
    Location
    Missouri
    Posts
    4,696
    Thanks
    25
    Thanked 658 Times in 657 Posts
    You need to post the search code.

  • #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
    •