Best way to fix spelling errors and eliminating duplicate rows?

Databases
1

I am currently using this query to fix misspellings in my searches table:

[FONT=Menlo]UPDATE searches SET keyword = REPLACECOLOR=#000000 WHERE keyword LIKE ‘%lavendar%’;[/FONT][/COLOR]

Many times I run into problems because of duplicate entries. This is because a user will search using the wrong spelling, and then they will search again with the correct spelling. I know how to use UPDATE IGNORE, to skip those problems but is there a way to do something like UPDATE DELETE? I would like to fix the spelling error, but if it causes a duplicate entry, then I would just like that row to be deleted.

Thanks!

2

best way to fix spelling errors – don’t let users type keywords, have them select from a dropdown list and use foreign keys to enforce

best way to eliminate duplicate rows – UNIQUE constraints

there is no UPDATE DELETE – you would have to code up the equivalent using application language (php or whatever)