MYSQL command syntax error need urgent help
$10 USD
Paid on delivery
Hi there, I need a quick help, I try to run a command in mysql command line but I get a syntax error. I think the problem is the addational ' in the command. This part exactly: 'ia'
I just want a simple find and replace in my post_content.
Here is my command:
UPDATE bfelw_posts SET post_content = REPLACE(post_content, '[alert text="RECEPTKÁRTYA" border_color="#dd8500" bg_color="#dd9933" font_color="#ffffff" size="25" icon="arrow-circle-down" closeable="no"][/alert]', '[wpna hide='ia'][alert text="RECEPTKÁRTYA" border_color="#dd8500" bg_color="#dd9933" font_color="#ffffff" size="25" icon="arrow-circle-down" closeable="no"][/alert][/wpna]');
Any one any idea?
Project ID: #21528003
About the project
Awarded to:
Hello sir, i have 10 years of exp, i have read the description and ready to start work right now. ..................................
11 freelancers are bidding on average $15 for this job
I like to do this job. I'll inspect the issue and find the best possible solution for it ASAP. I'll use advance technologies like, PHP7, MySQL, HTML5, CSS3, JS, Jquery, Ajax, and Bootstrap, as per required. I'll give More
Hey. I want to do this project. Some of my skills are: PHP, MySQl, jQuery / Prototype, Javascript, HTML, CSS. Can start right away.
Hi, i can fix that problem in 1 minute for you, i know how the mysql syntax works, if you need me, wrote in private chat. Cheers
Hi, I am having 7 years of experience in SQL and I can help you solve the bug quickly as I am available right now. Thanks
Hi, I understand that you need: 1. MYSQL issue resolved. I have fair experience, I will do it. Please let me know. Thanks.
Greetings! I am WordPress/MySQL Expert and will resolve in couple of minutes. I am ready with my solution as well. Let's connect and resolve it NOW. Regards, Vaishali
Hi, There Thanks for reviewing my cover letter. I am DAMILARE OLADIPUPO, a professional and experts web developer with more than 5 years experienced in this mentioned field. PHP MYSQL AJAX JQUERY JAVASCRIPT CSS3 More
hello :) i computer Engineer and i want work with you give me more details and i will give you best work good luck
SET GLOBAL SQL_MODE=ANSI_QUOTES then [S]ingle quotes are for [S]trings ; [D]ouble quotes are for [D]atabase identifiers; The ` symbol is the same as the " symbol. You can use " with ANSI_QUOTES enabled. If you conta More