- Joined
- Mar 11, 2014
- Messages
- 233
- Points
- 18
When I run a command like this
It alerted errors
![Is regular expression enabled on Phpmyadmin.png](/data/attachments/1/1113-0d2641a1d9783cd74c0e44e10a33fdb3.jpg)
but when I run that command via CLI, it is executed and records are updated as required.
What is wrong here? seem my PHPmyadmin is enabling Regular Expression and it didn't accept characters as ? or . in my command. Any solutions for this?
Thanks in advance.
Code:
UPDATE my_table SET post = replace(post, 'http://www.example.com/index.php?categoryname', 'https://example.com/categoryname');
![Is regular expression enabled on Phpmyadmin.png](/data/attachments/1/1113-0d2641a1d9783cd74c0e44e10a33fdb3.jpg)
but when I run that command via CLI, it is executed and records are updated as required.
What is wrong here? seem my PHPmyadmin is enabling Regular Expression and it didn't accept characters as ? or . in my command. Any solutions for this?
Thanks in advance.