CREATE TABLE masking (
  id        INT          NOT NULL AUTO_INCREMENT PRIMARY KEY,
  firstname VARCHAR(100) NOT NULL,
  lastname  VARCHAR(100) NOT NULL
);
INSERT INTO masking (firstname, lastname) VALUES
  ('test1', 'mask1'),
  ('test2', 'mask2');

SELECT
  id,
  firstname,
  lastname
FROM masking;


SELECT
  id,
  firstname,
  concat(lastname)
FROM masking;
