> 
>    SELECT filename, hdrsubject FROM mail2db WHERE hdrfrom ~ ".*@example.com";
> 

FYI, you could use LIKE clause too.
Anyway, there is a REGEX clause in MySQL which will fulfill what you need :)
MySQL is FASTER. And it has regex support from a long time ago.
But this is another story.

-- 
Stefan Laudat
-------------
And on the seventh day, He exited from append mode.

Reply via email to