On Thu, May 29, 2003 at 01:23:08PM +1000, Daniel Rossi wrote:
>
> i am getting people to try and break a search engine i built , when
> we put in the word DB into the search query i get no results even if
> its there in the record , why is this ?
>
> WHERE MATCH (sl.shotlist , sl.slug , sl.summary) AGAINST ('DB' IN
> BOOLEAN MODE) LIMIT 0 , 10 ;
Because you haven't told MySQL to index 2 character words.
http://www.mysql.com/doc/en/Fulltext_Fine-tuning.html
Jeremy
--
Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo!
<[EMAIL PROTECTED]> | http://jeremy.zawodny.com/
MySQL 4.0.8: up 114 days, processed 3,575,496,646 queries (360/sec. avg)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
