# mysql lookups - expects specific data exim -d-all+lookup -be ${lookup mysql {select name from them where id='ph10';}} ${lookup mysql {select name from them where id='ph10';}} ${lookup mysql {select name from them where id='xxxx';}} ${lookup mysql {select name from them where id='nothing';}} ${lookup mysql {select id,name from them where id='nothing';}} ${lookup mysql {delete from them where id='nonexist';}} ${lookup mysql {select * from them where id='quote';}} ${lookup mysql {select * from them where id='filter';}} ${lookup mysql {select * from them where id='quote2';}} ${lookup mysql {select * from them where id='nlonly';}} ${lookup mysql {servers=x:localhost; select name from them where id='ph10';}} ${lookup mysql {servers=localhost:x; select name from them where id='ph10';}} ${lookup mysql {servers=localhost/test/root/:x; select name from them where id='ph10';}} ${lookup mysql {servers=HOST_IPV4/test/root/:localhost; select name from them where id='ph10';}} **** exim -d -bh 10.0.0.0 mail from: rcpt to: quit **** exim -odi -d ph10 Test message . ****