MySQL查询没有响应名称Bob

Question

Ok this my seem a bit odd, but when I try to run the mysql query within the PHP code or in phpmyadmin it doesn't return anything:

DELETE FROM `EmployeeNames` WHERE FirstName = 'Bob'

But when I run the same line but with the name Billy it is fine and is deleted

DELETE FROM `EmployeeNames` WHERE FirstName = 'Billy'

Does anyone have a clue why this is happening, because I cant seem to figure it out.

Thanks

Answer 1

That's probably because there is no record with FirstName = 'Bob' (OR) in essence your condition WHERE FirstName = 'Bob' doesn't matches any record.

If you really sure that there is record with FirstName = 'Bob' then try doing a select with that condition. Probably, use TRIM() function before comparing in case there is space and due to which it's not matching

 DELETE FROM `EmployeeNames` WHERE TRIM(FirstName) = 'Bob'