Unknown column

[floridaflatlander]

I keep getting an unknown column error and I've been staring at this for hours.

I've checked and double checked the column names(all are lower case) even copied and pasted them from the table to the sql but I keep getting the same error.

When I remove the referral_code = fa4cc5218dc647ee7345c84103938812 it works but I need that to update the right record.

 

The sql is

UPDATE emails SET joined = 1, id = 80 WHERE referral_code = fa4cc5218dc647ee7345c84103938812 AND mem_id = 26

 

error
Unknown column 'fa4cc5218dc647ee7345c84103938812' in 'where clause

 

 

Thanks in advance

s

[Barand]

Use quotes round the string value or SQL thinks it is a column name

UPDATE emails 
SET joined = 1, id = 80 
WHERE referral_code = 'fa4cc5218dc647ee7345c84103938812' AND mem_id = 26

[floridaflatlander]

Thanks that did it