Re: Simple update failure

[Barry Galbraith]

You begin pic_num with a back tick, but close it with an apostophe.

Best to leave out the back ticks altogether. They are only necessary if you use a reserved word as an identifier, and it's best to avoid doing that too.

Try

UPDATE rkurtz SET pic_desc='Denver Botanic Gardens' WHERE pic_num >= 5268 AND pic_num <= 5581;

But for this situation you can use BETWEEN. It's more readable.

http://dev.mysql.com/doc/refman/5.6/en/comparison-operators.html#operator_between

UPDATE rkurtz SET pic_desc='Denver Botanic Gardens' WHERE pic_num BETWEEN 5268 AND 5581;

Good luck,
Barry.