Mysql: #1292 - Truncated Incorrect Double Value: '...'

I'm trying to create a MySQL query to update PAN no of all members. Using the query below I keep getting this error and its not something I've come across before, google seems to o

Solution 1:

You are using wrong quotes (PEBCAK). The where clause is comparing the string 'MemberCode' with 5100. This forces MySQL to convert both values to double hence the warning. Change single quotes to backticks:

UPDATE if_membermaster SET PAN_No = 'ABCD1234D' WHERE `MemberCode` = 5100