# 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:<a@b>
rcpt to:<c@d>
quit
****
exim -odi -d ph10
Test message
.
****