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.
>
>
> Hi,
>
> I'm not sure if this query is possible. I'm trying to look
> through a table
> text field for a filter. So the text field would be a domain
> lookup and the
> filter might be something like ns1.istorm.ca
>
> I can get this too work, If the filter and the domain are the same :
>
> SELECT whois_domain.domain
> FROM whois_domain, filter
> WHERE (whois_domain.domain LIKE filter.filter)
>
> I can also get this too work :
>
> SELECT whois_domain.domain
> FROM whois_domain, filter
> WHERE (whois_domain.record LIKE '%ns1.istorm.ca%')
>
> But if I try to combine the two
>
> SELECT whois_domain.domain
> FROM whois_domain, filter
> WHERE (whois_domain.record LIKE '%filter.filter%')
>
> I'll only get whois_domain.record's that I've inserted the word
> filter.filter within.
>
> Can anyone help me ?
>
>
> _________________________________________________________________
> Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
>
>
> ---------------------------------------------------------------------
> Before posting, please check:
> http://www.mysql.com/manual.php (the manual)
> http://lists.mysql.com/ (the list archive)
>
> To request this thread, e-mail <[EMAIL PROTECTED]>
> To unsubscribe, e-mail <[EMAIL PROTECTED]>
> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
>
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
