Received: from qmsql.netservers.net (hpmail1.netservers.net [209.196.128.163]) by postgresql.org (Postfix) with SMTP id 0FBBE476004 for ; Fri, 22 Feb 2002 12:09:05 -0500 (EST) Received: (qmail 68646 invoked from network); 22 Feb 2002 17:09:09 -0000 Received: from unknown (HELO AARON) (66.26.63.73) by hpmail1.netservers.net with SMTP; 22 Feb 2002 17:09:09 -0000 Message-ID: <023101c1bbc3$03a33910$110a010a@headquarters.wcgroup.com> From: "Samuel J. Sutjiono" To: , Subject: Regular Expression for 'and' instead of 'or' Date: Fri, 22 Feb 2002 12:04:38 -0500 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_022E_01C1BB99.1A578BE0" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.50.4522.1200 X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200 X-Archive-Number: 200202/1059 X-Sequence-Number: 21056 This is a multi-part message in MIME format. ------=_NextPart_000_022E_01C1BB99.1A578BE0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable This expression matches the word socks or shoes or nike in product category= =20 where productdescr ~* '(socks|shoes|nike)' Does anybody know what the expression should be if I want to do 'and' of t= hose key words instead of 'or' ? Thanks, Sam=20 ------=_NextPart_000_022E_01C1BB99.1A578BE0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
This expression matches the word socks or = shoes or=20 nike in product category 
where productdescr ~*=20 '(socks|shoes|nike)'
 
Does anybody know what the expression= should=20 be  if I want to do 'and' of those key words ins= tead=20 of 'or' ?
 
Thanks,
Sam 
------=_NextPart_000_022E_01C1BB99.1A578BE0--