<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:arial,helvetica,sans-serif;font-size:10pt">hi,<br>I have table "tasks"<br><br>create table tasks(<br>task_id, int(4) not null primary key, <br>task text not null, <br>resolution text not null, <br>fulltext (task, resolution)<br>)engine=myisam<br><br><br>> select count(*) from tasks match(task,resolution) against('"certain service"' in boolean mode)<br>result: 1 <br>> select * from tasks where task like '%certain service%' or resolution like '%certain service%'<br>result: 2 . <br><br><br>> select count(*) from tasks match(task,resolution) against('+certain +service' in boolean mode) <br>result: 232 <br>> select * from tasks where (task like '%certain%' and task like '%service%') or (resolution like '%certain%' and resolution like '%service%')<br>result: 7 <br><br><br>> select count(*) from tasks match(task,resolution) against('certain')
<br>result: 0<br>> select count(*) from tasks where task like '%certain%' or resolution like '%certain%'; <br>result: 173<br><br>just in case, I restarted mysql server and "repaired" the table<br>> repair table tasks quick;<br>still the same.<br><br><br>what I'm doing wrong?<br><br>thanks.<br><br>-afan<br><br></div><br>
<hr size=1>Be a better friend, newshound, and
know-it-all with Yahoo! Mobile. <a href="http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ "> Try it now.</a></body></html>