Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2003
    Posts
    2

    Unanswered: getting errors while trying to use freetext query

    I am trying to use the following code to search through a table called corpusData. The field where i am searching is called Paragraph and I am tryng to use the following code....


    select * from corpusData where contains(Paragraph, ' "test string" ')

    But i keep getting the following error...

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '( Paragraph, ' "test string" ') LIMIT 0, 30' at line 3


    Can anyone help?

    thanks in advance

  2. #2
    Join Date
    Aug 2003
    Posts
    2

    Re: getting errors while trying to use freetext query

    I know I said Freetext but included the CONTAINS method... I have been trying to use both... but both give me the same error....

    pls help...

Posting Permissions

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