From: "A. Sasaki" <asasaki@gmail.com>
Content-Type: multipart/alternative;
	boundary=Apple-Mail-C0D14F18-8764-4B6C-AB87-A943B4369ED0
Content-Transfer-Encoding: 7bit
Mime-Version: 1.0 (1.0)
Date: Sun, 4 Nov 2018 09:20:42 -1000
Subject: Re: Regular Expressions
Message-Id: <1D0900B9-EE3F-4960-8762-B7CE6D4D59EE@gmail.com>
References: <012401d47472$0ebc9240$2c35b6c0$@gmail.com>
In-Reply-To: <012401d47472$0ebc9240$2c35b6c0$@gmail.com>
To: pgsql-sql@lists.postgresql.org
Precedence: bulk


--Apple-Mail-C0D14F18-8764-4B6C-AB87-A943B4369ED0
Content-Type: text/plain;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

=E2=80=98(*\mtext1\M*\mtext2\M)|(*\mtext2\M*\mtext1\M)=E2=80=99

Thanks,

-Andrew-

> On Nov 4, 2018, at 9:10 AM, Mark Williams <markwillimas@gmail.com> wrote:
>=20
> If I wanted to search for whole words in a field I would use something lik=
e:
> =20
> Select * from mytable where myfield ~* =E2=80=98(\mtext1\M) | (\mtext2\M)=E2=
=80=99
> =20
> This would find all instances of myfield containing either =E2=80=9Ctext1=E2=
=80=9D or =E2=80=9Ctext2=E2=80=9D.
> =20
> I can=E2=80=99t figure out how to search myfield for all instances which c=
ontain =E2=80=9Ctext1=E2=80=9D AND =E2=80=9Ctext2=E2=80=9D.
> =20
> In other words | is the OR operator. What is the AND operator. Tried + and=
 whilst that executes, it doesn=E2=80=99t return matching fields.
> =20
> Thanks
> =20
> Mark
> =20
> __
> =20

--Apple-Mail-C0D14F18-8764-4B6C-AB87-A943B4369ED0
Content-Type: text/html;
	charset=utf-8
Content-Transfer-Encoding: quoted-printable

<html><head><meta http-equiv=3D"content-type" content=3D"text/html; charset=3D=
utf-8"></head><body dir=3D"auto"><div dir=3D"ltr"><div class=3D"WordSection1=
"><p class=3D"MsoNormal"><font color=3D"#000000" face=3D"UICTFontTextStyleTa=
llBody" size=3D"3"><span style=3D"caret-color: rgb(0, 0, 0); background-colo=
r: rgba(255, 255, 255, 0);">=E2=80=98(*\mtext1\M*\mtext2\M)|(*</span></font>=
<font face=3D"UICTFontTextStyleTallBody" size=3D"3"><span style=3D"backgroun=
d-color: rgba(255, 255, 255, 0);">\mtext2\M*\mtext1\M)</span></font><span st=
yle=3D"font-family: UICTFontTextStyleTallBody; font-size: medium; background=
-color: rgba(255, 255, 255, 0);">=E2=80=99</span></p></div></div><div><br></=
div><div id=3D"AppleMailSignature" dir=3D"ltr">Thanks,<div><br></div><div>-A=
ndrew-</div></div><div dir=3D"ltr"><br>On Nov 4, 2018, at 9:10 AM, Mark Will=
iams &lt;<a href=3D"mailto:markwillimas@gmail.com">markwillimas@gmail.com</a=
>&gt; wrote:<br><br></div><blockquote type=3D"cite"><div dir=3D"ltr"><meta h=
ttp-equiv=3D"Content-Type" content=3D"text/html; charset=3Dus-ascii"><meta n=
ame=3D"Generator" content=3D"Microsoft Word 15 (filtered medium)"><style><!-=
-
/* Font Definitions */
@font-face
	{font-family:"Cambria Math";
	panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
	{font-family:Calibri;
	panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
	{margin:0cm;
	margin-bottom:.0001pt;
	font-size:11.0pt;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
a:link, span.MsoHyperlink
	{mso-style-priority:99;
	color:#0563C1;
	text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
	{mso-style-priority:99;
	color:#954F72;
	text-decoration:underline;}
span.EmailStyle17
	{mso-style-type:personal-compose;
	font-family:"Calibri",sans-serif;
	color:windowtext;}
.MsoChpDefault
	{mso-style-type:export-only;
	font-family:"Calibri",sans-serif;
	mso-fareast-language:EN-US;}
@page WordSection1
	{size:612.0pt 792.0pt;
	margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
	{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext=3D"edit" spidmax=3D"1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext=3D"edit">
<o:idmap v:ext=3D"edit" data=3D"1" />
</o:shapelayout></xml><![endif]--><div class=3D"WordSection1"><p class=3D"Ms=
oNormal">If I wanted to search for whole words in a field I would use someth=
ing like:<o:p></o:p></p><p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p><p class=
=3D"MsoNormal">Select * from mytable where myfield ~* =E2=80=98(\mtext1\M) |=
 (\mtext2\M)=E2=80=99<o:p></o:p></p><p class=3D"MsoNormal"><o:p>&nbsp;</o:p>=
</p><p class=3D"MsoNormal">This would find all instances of myfield containi=
ng either =E2=80=9Ctext1=E2=80=9D or =E2=80=9Ctext2=E2=80=9D.<o:p></o:p></p>=
<p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p><p class=3D"MsoNormal">I can=E2=80=
=99t figure out how to search myfield for all instances which contain =E2=80=
=9Ctext1=E2=80=9D AND =E2=80=9Ctext2=E2=80=9D.<o:p></o:p></p><p class=3D"Mso=
Normal"><o:p>&nbsp;</o:p></p><p class=3D"MsoNormal">In other words | is the O=
R operator. What is the AND operator. Tried + and whilst that executes, it d=
oesn=E2=80=99t return matching fields.<o:p></o:p></p><p class=3D"MsoNormal">=
<o:p>&nbsp;</o:p></p><p class=3D"MsoNormal">Thanks<o:p></o:p></p><p class=3D=
"MsoNormal"><o:p>&nbsp;</o:p></p><p class=3D"MsoNormal">Mark<o:p></o:p></p><=
p class=3D"MsoNormal"><o:p>&nbsp;</o:p></p><p class=3D"MsoNormal"><span styl=
e=3D"mso-fareast-language:EN-GB">__<o:p></o:p></span></p><p class=3D"MsoNorm=
al"><o:p>&nbsp;</o:p></p></div></div></blockquote></body></html>=

--Apple-Mail-C0D14F18-8764-4B6C-AB87-A943B4369ED0--