|
-
April 9th, 2009, 10:18 AM
#1
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.
-
April 9th, 2009, 10:26 AM
#2
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|