I have a table with a field "key" containing a unique value. I have a second table containing a field called "keys" containg a pipe-delimited list of values from the "key" table.
I'd like to do a query that took each value from key, and matched it agains the field "keys" in the second table, and returned a third table of unique key values from the first table, and number of matches from the second table. I've already set up a full text index for the values in the second table and have done successful matches in simpler queries. Make sense? The table I'd like to generate might look like this: key matches blue 50 yellow 6 green 29 This would indicate that there were 3 key values in the first table (blue, yellow, green), and, respectively, there were 50, 6, and 20 matches for each term in the second table. Can somebody help me do this? Thanks! -Bob -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
