mysql> select * from settings where value = 'RecordFilePrefix'; +------------------+----------------------------+-------------+ | value | data | hostname | +------------------+----------------------------+-------------+ | RecordFilePrefix | /vault/recordings | myth-back | | RecordFilePrefix | /var/lib/mythtv/recordings | myth-front | | RecordFilePrefix | /var/lib/mythtv/recordings | OLDHOSTNAME | +------------------+----------------------------+-------------+ 3 rows in set (0.00 sec)