--- Lamp Lists <[EMAIL PROTECTED]> wrote:
>
> --- Lamp Lists <[EMAIL PROTECTED]> wrote:
>
> > hi,
> > I created table "tasks"
> > create table tasks(
> > task_id, int(4) not null primary key,
> > task text not null,
> > resolution text not null,
> > fulltext (task, resolution)
> > )engine=myisam
> >
> > when I run
> >
> > seect * from tasks match(task,resolution)
> > against('"certain service"' in boolean mode)
> >
> > I would get one record and the phrase is in
> > resolution
> > column.
> >
> > though, when I serach using LIKE
> > select * from tasks where task like '%certain
> > service%' or resolution like '%certain service%'
> > I would get 2 records. one record is the same as
> the
> > one above and the 2nd has the phrase in task
> column.
> > means there are 2 records, but fulltext shows me
> > only
> > one.
> >
> > what I'm doing wrong?
> >
> > thanks.
> >
> > -ll
> >
>
>
> just made 2nd test and got different reault too:
>
> select * from tasks match(task,resolution)
> against('+certain +service' in boolean mode)
> result: 232 records
>
> select * from tasks where (task like '%certain%' and
> task like '%service%') or (resolution like
> '%certain%'
> and resolution like '%service%')
> result: 7 records
>
> ?!?!!??
>
> -ll
>
>
>
>
>
>
____________________________________________________________________________________
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.
>
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
>
>
>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
>
http://lists.mysql.com/[EMAIL PROTECTED]
>
>
even worse:
select count(*) from tasks match(task,resolution)
against('certain')
result: 0
select count(*) from tasks where task like '%certain%'
or resolution like '%certain%';
result: 173
?????
-ll
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
