mySQL UPDATE query returns "0 rows affected"

Question

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.

Answer 1

Try select count(*) from phonecalls where PhoneNumber = "999 29-4655"; That will give you the number of matching rows. If the result is 0, then there isn't a row in the database that matches.-

Answer 2

Check to make sure this returns some result.

SELECT * FROM phonecalls WHERE PhoneNumber = '999 29-4655'

If it doesn't return any result than the filter WHERE PhoneNumber = '999 29-4655' is not correct.

Answer 3

The problem might be that there are no records with PhoneNumber == "999 29-4655".

Try this query:

SELECT * FROM phonecalls where PhoneNumber = '999 29-4655'

If it doesn't return anything, then there are no rows that match.

Answer 4

As amphetamine and Yada suggested, check with a SELECT, if your phone number is in the table.

But keep in mind: If the value for called of the row in question is already "Yes", mysql won't change the value and will therefore return "0 rows affected". So be sure to also check the current value of called

Answer 5

1. Does it say Rows matched: 1 Changed: 0 Warnings: 0? Then maybe it's already set to that value.
2. Did you try single quotes vs. double quotes?
3. "999 29-4655" is the space a space or a tab and is it consistent in your query and the database?

Answer 6

That's my sugestion:

UPDATE `phonecalls` SET `Called` = 'yeah!' WHERE `PhoneNumber` = '999 29-4655' AND `Called` != 'yeah!'

And make sure with the case-sensitive name of table and field`s.