Hi,
I'm trying to execute the following query,when creating new data source
SELECT LOWER(CONCAT('asset2_',REPLACE(AssetType,' ','_'))) FROM assettype2
However, I'm getting these errors.
Error #1088 and #1099
any help?
CONCAT / LOWER / REPLACE in MYSQL Query
Re: CONCAT / LOWER / REPLACE in MYSQL Query
Hello.
Did you try to run this query on your mysql database? Is it right?
Could you also specify which version of our product you use?
Thank you.
Did you try to run this query on your mysql database? Is it right?
Could you also specify which version of our product you use?
Thank you.