hi,

i have a field called KEYWORDS that stores several words describing  an 
item .

if a user types "work" , i'm able to show all the records that 
contain "work" in the keywords field using -

select * from products where keywords like '%work%'

Additionally i want to show 2 categories -
records with Exact matches & records with closely-related matches and also 
a * new * column based on keywords showing the words which were matched.


Exact match 
===============================================
product  keywords               *NEW* column
-------  -------------------   --------------

xyz       work civil labor      work


Related matches
================================================
product  keyword                   *NEW* column
-------  ---------------------   ---------------
abc      hard-work beer simpson   hard-work
def      working vodka pint oz    working

i guess i can show an exact match using
select * from products where keywords like 'work' . 
i'd like to know how i can show the new column showing the matching words 
(exact & related )


thanks for your time,
:-)rk