Professional Web Applications Themes

Very strange problem - MySQL

I have a column in a table that is configured for full text searching. I can search the DB with this: SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST ('"add"' IN BOOLEAN MODE); It will not return results when searching for the work "add" or ("Add" or any other variant). It can find phases that include the word "add" like this: SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST ('"add to base"' IN BOOLEAN MODE); That works fine. It can also find records with any other single word that I've tested. I'm using the command line interface in Linux and ...

Sponsored Links
  1. #1

    Default Very strange problem

    I have a column in a table that is configured for full text searching.
    I can search the DB with this:


    SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
    ('"add"' IN BOOLEAN MODE);


    It will not return results when searching for the work "add" or ("Add"
    or any other variant). It can find phases that include the word "add"
    like this:

    SELECT * FROM mydb.MyTable where MATCH (strFullTextColumn) AGAINST
    ('"add to base"' IN BOOLEAN MODE);

    That works fine. It can also find records with any other single word
    that I've tested. I'm using the command line interface in Linux and
    using the Query Browser Client in windows with the same results. Any
    idea what's going on here? What am I missing?

    Sponsored Links
    Bruce Guest

  2. #2

    Default Re: Very strange problem

    Bruce wrote: 

    You're missing that bit where you read the manual and it says:
    "The default minimum value is four characters;"


    Paul Guest

  3. #3

    Default Re: Very strange problem

    Yep, I missed that. Thanks.



    Paul Lautman wrote: 
    >
    > You're missing that bit where you read the manual and it says:
    > "The default minimum value is four characters;"[/ref]

    Bruce Guest

  4. #4

    Default Re: Very strange problem

    Bruce wrote: 
    >>
    >> You're missing that bit where you read the manual and it says:
    >> "The default minimum value is four characters;"[/ref][/ref]

    Be sure and read the next bit that says that you can change this value.


    Paul Guest

  5. #5

    Default Re: Very strange problem

    I changed the variable and it worked. Thanks for you help!

    Bruce Guest

Similar Threads

  1. Strange Problem with XML
    By kandy71@gmail.com in forum Macromedia Flex General Discussion
    Replies: 0
    Last Post: December 3rd, 01:03 AM
  2. Strange FDF problem
    By Hello in forum Adobe Acrobat SDK
    Replies: 0
    Last Post: June 15th, 05:56 PM
  3. Strange problem on IE6
    By jrstudios in forum Macromedia Flash Player
    Replies: 1
    Last Post: September 29th, 11:07 AM
  4. [PHP] Strange Problem
    By Philip Olson in forum PHP Development
    Replies: 0
    Last Post: July 14th, 03:42 PM

Bookmarks

Posting Permissions

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

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139