acctman Posted May 22, 2009 Share Posted May 22, 2009 why am i getting this 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 '%Bergen%' at line 1 UPDATE rate_members SET m_state = replace(m_state,"Fl","FL") WHERE m_city LIKE %Bergen% Quote Link to comment https://forums.phpfreaks.com/topic/159265-solved-syntax-error/ Share on other sites More sharing options...
Ken2k7 Posted May 22, 2009 Share Posted May 22, 2009 Put %Bergen% in quotes. Quote Link to comment https://forums.phpfreaks.com/topic/159265-solved-syntax-error/#findComment-839990 Share on other sites More sharing options...
acctman Posted May 22, 2009 Author Share Posted May 22, 2009 thanks Quote Link to comment https://forums.phpfreaks.com/topic/159265-solved-syntax-error/#findComment-839994 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.