SQL update function, know which cell I want, how to find row

I want to update a row like this:

_id, AttributeA, AttributeB, AttributeC

I need to find a row based on AttributeC so tha开发者_开发问答t I can update it, lets say the desired AttributeC contains value "X"

How would this be done?

I believe this would be done with a WHERE argument but can I get this whole statement spelled out?

Something like

UPDATE table
SET AttributeB='value'
WHERE AttributeA = 'X'

This will update all rows where AttributeA = 'X' and set AttributeB to 'value', if there are more than 1.

Start by looking at the UPDATE syntax. If you get stuck, show us what you've tried and we can help further

update TableA 
set AttributeC = 'XXX' 
where AttributeC like "%X%"