Full Text search not working...
Posted: Wed Jul 20, 2005 11:09 am
Hi,
I am trying to conduct a full text search on a field in my DB.
The Query is structured as such:
I have set up the 'description' field with a FULL TEXT index.
I have added a record with the value 'This is a test.' to the table.
When I search using the above query, I get 0 rows returned.
I'm perplexed as to why this isn't working. Any suggestions for troubleshooting?
Thanks!
I am trying to conduct a full text search on a field in my DB.
The Query is structured as such:
Code: Select all
SELECT * FROM helpsources_tb WHERE MATCH (description) AGAINST ('test')I have added a record with the value 'This is a test.' to the table.
When I search using the above query, I get 0 rows returned.
I'm perplexed as to why this isn't working. Any suggestions for troubleshooting?
Thanks!