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