newsblurb_id int(11) Primary auto_increment
subject varchar(255)
body longtext
postedby varchar(20)
date datetime
show char(1) Y
When I attempt the UPDATE (updating show from Y to N):
UPDATE newsblurb set (subject='testsubject', body='testbody', show='N') where (newsblurb_id='1')
For some reason, I get this error:
ERROR 1064: You have an error in your SQL syntax near 'show='N' where newsblurb_id='1'' at line 1
I have tried and tried and tried. I have searched all over the internet, used sqlcourse.com and searched the mysql documentation, and I can't find what I am doing wrong here.
I greatly appreciate any help I can get.
-redptam-