Hi there

Can anyone help me on this please?

I would like to insert additional words in to my keywords field to improve the search results but without deleting existing words.

So if the title of the article has the word 'accounting' in it I would like to add the words 'accountants' and 'accountancy' in to the keywords and then the article will be returned more often in search results.

But here is the difficult part, as there are already some keywords enetered, the code must not delete those entries when it inserts the new keywords

So i tried UPDATE IGNORE table SET keywords="" WHERE title=""

Bu this just deletes my old keywords and replaces them with thenew ones

Can anyone help?

Thanks

Can anyone advise me on the correct MySQL code for the above database change?

Thanks a lot

See this discussion...

I hope, it helps.

that's perfect! thanks a lot Mamba!!!