CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2009
    Posts
    18

    MySQL and FULLTEXT searching

    I am having trouble with searching in my MySQL database. I do have FULLTEXT assigned to my table here is my code:

    SELECT * FROM btt.btt WHERE MATCH(Solution) AGAINST ('the' IN BOOLEAN MODE)

    this returns 0 results when in reality many results should have came back.

    Any ideas what I am doing wrong? I have read all the articles on the MySQL pages and it seems I am doing things correctly but obviously I am missing something.

  2. #2
    Join Date
    Feb 2009
    Posts
    18

    Re: MySQL and FULLTEXT searching

    I found my answer, MySQL will only allow for searching of 4 characters and higher.

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

Featured