use :
SELECT whois_domain.domain
FROM whois_domain, filter
WHERE (whois_domain.record LIKE concat('%',filter.filter,'%')
TK
-Opprinnelig melding-
Fra: abercrombie fitch [mailto:[EMAIL PROTECTED]]
Sendt: 30. oktober 2001 13:35
Til: [EMAIL PROTECTED]
Emne: LIKE '%%' with fields.
ehh .. forgot a ) on my sql.
the right one is below
SELECT whois_domain.domain
FROM whois_domain, filter
WHERE (whois_domain.record LIKE concat('%',filter.filter,'%'))
TK
-Opprinnelig melding-
Fra: abercrombie fitch [mailto:[EMAIL PROTECTED]]
Sendt: 30. oktober 2001 13:35
Til: