crap, sorry, I made a mistake in my posting.

> (You might try
> ...WHERE 'test@e...' LIKE addr
> but I don't know if that's supported syntax. If it is, it should
> return a match.)

yeah you're right, it should have been:

SELECT * FROM foo WHERE 'test@...' LIKE addr;

which should, IMHO, work fine.