[SOLVED] delete word from field

[breadcom]

This should be easy but every query I've tried hasn't worked. I have a table called locations. I want to delete the word Apple from anywhere in the field labeled categories. Currently some categories fields contain Apple, Raisin and some just Raisin. Can someone let me know the query to do this.  I thought the following would do the trick.

 

DELETE FROM 'locations'

WHERE notes = 'Apple'

 

Thanks.

[gevensen]

locations should be `locations ` not 'locations'

[breadcom]

Sorry I meant . . .

 

DELETE FROM `locations` WHERE `Apple`;

[gevensen]

Sorry I meant . . .

 

DELETE FROM `locations` WHERE `Apple`;

 

for example

 

DELETE FROM `locations` WHERE `word` = `Apple`;

[breadcom]

What does `word` represent? I thought that was where the field had to go which in this case is notes. That hasn't worked. I'm good at creating just not deleting I guess. Thanks for your help.

[fenway]

Backticks and single quotes are not interchangeable.  And post the actual error as well...

[DavidAM]

Are you saying you have a table like this:

Notes
=====
Apple
Raisin
Banana
Apple, Raisin
Apple, Banana
Mango, Apple

and you want to remove the word apple from the notes field leaving the rest of the field as is?

 

Notes
=====
<BLANK>
Raisin
Banana
, Raisin
, Banana
Mango, 

 

If so, you need to use the REPLACE function

UPDATE locations SET notes = REPLACE(notes, 'Apple', '') WHERE notes LIKE '%Apple%'

 

[breadcom]

Yes. Perfect. Thank you very much!!