Mysql query "Undefined function 'replace' in expression"



Hi there, when I run the following Mysql query
Update [Sheet1$]
Set url =replace(url,’//www’,‘www’)
I get : Execute query : Undefined function ‘replace’ in expression.

Whats the correct syntax ?

I am using Microsoft.ACE.OLEDB.12.0.

Since Uipath is 32-bit, I am using 32bit Microsoft.ACE.OLEDB.12.0. from office 2007. I also have 64bit Winautomation installed on the same machine with 64 bit Microsoft.ACE.OLEDB.12.0 for office 2010 and it works fine with mysql replace function.

I think the problem is , that uipath sees replace as a VB function and not Mysql function.


Undefined function 'replace' in expression in execute Query

I have solved the issue by upgrading to Microsoft Access Database Engine 2010 Redistributable from .