• Registered: 2017-12-10
  • Posts: 81

Topic: Calculated Field

In sqlite the calculated field works well, but not in MySql: ifnull(firstname,'')||' '||ifnull(lastname,''). How can I get it work in Mysql?

kees.krause's Website

  • derek
  • derek
  • Moderator
  • Offline
  • Registered: 2015-02-16
  • Posts: 2,681

Re: Calculated Field

Hi Kees,
Try it as
concat(expression1,"literal2 ", expression3)  and so on.
I think that should work (but I dont use MySQL so can't check it).
Derek.

3 Reply by brian.zaballa (edited by brian.zaballa 2021-03-02 13:46:04)

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

Re: Calculated Field

you can also try 

CONCAT(COALESCE(firstname,''),' ',COALESCE(lastname,''))

But you can also use and retain function IFNULL instead of COALESCE as Derek's Code. It'll work just fine too.

brian
  • Registered: 2017-12-10
  • Posts: 81

Re: Calculated Field

Thanks Derek and Brian. It works for me fine.

kees.krause's Website