Re: Questions on full text searching

[Rick James]

Is this really a FULLTEXT question? Seems like ParcelID should be an exact match.

Consider the following:

SELECT id FROM asmnt_parcel WHERE Account = '{$search}'
UNION DISTINCT
SELECT id FROM asmnt_parcel WHERE MATCH('$search') AGAINST (OwnersName)
UNION DISTINCT
...

Most of those will come up empty because an account number is a number but an Owner name is characters. That's ok. Then look up the ids to get the info.

To do both steps at once:

SELECT lots of fields
   FROM main_table AS m
   JOIN (
      SELECT ...
      UNION DISTINCT
      SELECT ...
      ...
        ) AS u   ON m.id = u.id