Search Matching

Is there some easy way to:

1. Match multiple fields with the same key

select * from table where * ~* 'key';

2. Get a count of the number of matches:

EG:

table:
First | Last
--------------------
John | Doe
Jane | Doe
John | Johnson

I need a query that given 'John' and 'Doe' would return something like:

Score | First | Last
-----------------------
2 | John | Doe
2 | John | Johnson
1 | Jane | Doe

I guess I want a search engine just like the big boys, but I don't want to
get too carried away with coding it up in PHP if there's some SQL that will
do it faster/better. :-)

--
--
-- "TANSTAAFL" Rich lynch(at)lscorp(dot)com