mysql> SELECT email as user, concat('*:storage=', quota_kb, 'K') AS quota_rule2, password, 5000 as uid, 5000 as gid, '/home/vmail/%d/%n' as home FROM view_users_quota WHERE email=' sebastian@vandemeer.de'; +------------------------+--------------------+----------------------------------+------+------+------------------+ | user | quota_rule2 | password | uid | gid | home | +------------------------+--------------------+----------------------------------+------+------+------------------+ | sebastian@vandemeer.de | *:storage=2048000K | xxxxxxxxxxxxxxxxxxxxxxx| 5000 | 5000 | /home/vmail/%d/%n | +------------------------+--------------------+----------------------------------+------+------+------------------+ 1 row in set (0.00 sec)