sql query for remove some keywords

[Antony]

Somebody knows the sql command to remove one keywords in all idx link ?

For exemple i want to remove the keyword "with" in all links.

Thank's

[FSGDAG]

Try this...

delete from idx_link where keyword = xxxxxxx

[Antony]

Thank's but doesn't work...

[Bruceper]

delete from idx_link where keyword = xxxxxxx will delete any link with a matching keyword. This will not simply remove the keyword.

Replace the word replaceme with nothing

update idx_link set keywords = REPLACE(keywords,"replaceme","")

[Antony]

Its working find. Thank's to all.
Antony