SELECT is using wrong key AND getting wrong results

2002-03-15 Thread Michael Widenius
Hi! > "Mike" == Mike Wexler <[EMAIL PROTECTED]> writes: >> Description: Mike> SELECT fullTextMatches.realname, fullTextMatches.address, Mike>fullTextMatches.address2, fullTextMatches.city, Mike> fullTextMatches.state, Mike>fullTextMatches.zip, fullTextMatches.country, Mike>

SELECT is using wrong key AND getting wrong results

2002-03-13 Thread Mike Wexler
>Description: SELECT fullTextMatches.realname, fullTextMatches.address, fullTextMatches.address2, fullTextMatches.city, fullTextMatches.state, fullTextMatches.zip, fullTextMatches.country, fullTextMatches.email, fullTextMatches.homephone, fullTextMatches.workphone, full