• Registered: 2014-06-25
  • Posts: 863

Re: Using a component in a filter query

tcoton wrote:
sparrow wrote:

Derek described everything.

It is advisable to simply replace the space character with an unused character. Then there will be no false positives.
Example:

trim(ifnull(info1||'§','')||ifnull(info2||'§',''))

Hi all,

Any idea on how to translate this Sqlite version to MySQL? I get a ton of errors while trying to tweak it to fit MySQL and I am not far from the headache.

I got my answer, there is nothing to translate, one must enable the SQL_MODE "PIPES_AS_CONCAT" at the global parameter on the server.

SET GLOBAL sql_mode = (SELECT CONCAT(@@sql_mode,',PIPES_AS_CONCAT'));

I am wondering if it would be possible to push only a session sql_mode when the application connects to the server even after a timeout.

  • From: Philippines
  • Registered: 2018-10-23
  • Posts: 417

Re: Using a component in a filter query

tcoton wrote:
sparrow wrote:

Derek described everything.

It is advisable to simply replace the space character with an unused character. Then there will be no false positives.
Example:

trim(ifnull(info1||'§','')||ifnull(info2||'§',''))

Hi all,

Any idea on how to translate this Sqlite version to MySQL? I get a ton of errors while trying to tweak it to fit MySQL and I am not far from the headache.

try

trim(concat(ifnull(CONCAT(info1,'§'),''),ifnull(CONCAT(info2,'§'),'')))
brian
  • Registered: 2014-06-25
  • Posts: 863

Re: Using a component in a filter query

Thanks Brian.zaballa, it works too!! I was not using the very first concat, only the ones after the ifnull.