Comparing Mysql fields

[richclever]

Hi, I have a table with a field called keywords. In this field, there is a comma delimited list of keywords. I need to compare this field for a particular record with all the other records to find any records that have the same or similar entries in their lists.

e.g. Record1 has the following words in the keyword field
- potato, potatoes, varieties, gardening,
garden, new potatoes
Record2 has the following words in the keyword field
- Robert Burns, Burn's Night, haggis, Rabbie
Burns, scots, scotland, garden

Obviously both fields have the word 'garden', I need to know how to recognise this and flag the second one so it can be identified as being related.

Sorry about the convoluted explanation of my problem but I couldn't think of any other way to put it.

Thanks in advance,

Richard

 

[kenrbnsn]

Take each 'keyword' field, turn it into an array

$arr1 = explode(',',$record1['keyword']);
$arr2 = explode(',',$record2['keyword']);

and use one of the array functions (see <

http://us4.php.net/manual/en/ref.array.php>)

to do the comparision. Based on the results, set your flag accordingly.

Ken

 

[Olavxxx]

if you want to find something which is not EQUALS, but LIKE, use the LIKE..

eg. LIKE '%keyword%'

% = wildcard

Another function which might be usefull is HAVING

http://www.mysql.com

Olav Alexander Mjelde

http://www.volvo-power.net

Admin & Webmaster