[UPHPU] Query Help

[John David Anderson]

On Apr 5, 2007, at 3:09 PM, Webot Graphics wrote:

>> You need a comma between the * and MATCH.  Think of it as you are  
>> selecting all fields in the table (*) AND the score of the MATCH.   
>> It is a list that is comma separated.
>
> This stopped the errors from coming, but I am not getting any  
> results, even when I type in the name of one of the rows exactly
>
> i was thinking that this might be a problem with the full text  
> index, so this is what I did in MySQL Administrator
> is there something that I need to change in my SQL statement?

By default, a fulltext search will remove any term that appears in  
half of the rows of the results. If all your words are in half the  
results, you might get back an empty query.

-- John