I have a column/field 'policy_type' that have 'HO Prefe' that I need to correct to 'HOP'... I followed a previous post..How can I update some incorrect fields in a column?
I keep getting a 1064 error?... Can anyone tell me what's wrong with this?
Query:
1.SELECT * FROM quick_rates WHERE company_id=(6)
2.UPDATE quick_rates SET policy_type='HOP' WHERE policy_type='HO Prefe'
Update a column
Thanks for the quick reply:.. here is the entire message:
SQL Error (1064); You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE quick_rates SET policy_type='HOP' WHERE policy_type='HO Prefe'at line 2
SQL Error (1064); You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'UPDATE quick_rates SET policy_type='HOP' WHERE policy_type='HO Prefe'at line 2
Please login to leave a reply, or register at first.