Dopani
Well-known member
- Joined
- Mar 11, 2014
- Messages
- 233
- Points
- 18
When I run a command like this
It alerted errors
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');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.
