yet another developer pwned by mysql's evil `backticks`
backticks are used to delimit identifiers, i.e. column and table names
everything in red below is regarded as a column name --
here's my advice: don't use backticks!!
SET `street` = `535 E 18th St`
, `town` = `Flatbush - Ditmas Park`
, `city` = `Kings`
, `state` = `New York`
, `country` = `United States`
, `zipcode` = `11226`
, `coordinates` = `40.63763458315378, -73.96082556740572`
, `phone` = `4657345908`
, `website` = `http://www.someurl.com`
, `favoritebook` = `some book`
, `aboutme` = `some details about me`
, `birthdate` = `05-16-2012`
WHERE `id` = `42`
note the birthdate value won't insert properly if birthdate is an actual DATE datatype
SET street = '535 E 18th St'
, town = 'Flatbush - Ditmas Park'
, city = 'Kings'
, state = 'New York'
, country = 'United States'
, zipcode = '11226'
, coordinates = '40.63763458315378, -73.96082556740572'
, phone = '4657345908'
, website = 'http://www.someurl.com'
, favoritebook = 'some book'
, aboutme = 'some details about me'
, birthdate = '05-16-2012'
WHERE id = 42
note also there are no quotes around 42 because id is presumably a numeric column