I have this query:
UPDATE phonecalls SET Called = "Yes" WHERE PhoneNumber = "999 29-4655"
My table is
phonecalls, I have a column named
PhoneNumber. All I want to update is a column named
Called to “yes”.
Any idea what I am doing wrong? when I return my query it says 0 rows affected.
If the such value already exists, mysql won’t change it and will therefore return "0 rows affected". So be sure to also check the current value of
Answered By – Dan Soap
Answer Checked By – Candace Johnson (BugsFixing Volunteer)