Received: from fw.ckpg.com.au (IDENT:root@[203.111.54.51]) by hub.org (8.9.3/8.9.3) with ESMTP id WAA26845 for ; Sun, 4 Jul 1999 22:50:27 -0400 (EDT) (envelope-from Gary_Lazarus@ckpg.com.au) Received: from mail.main.ckpg.in (IDENT:root@mail.main.ckpg.in [192.168.2.5]) by fw.ckpg.com.au (8.9.1/8.9.1) with ESMTP id MAA07136 for ; Mon, 5 Jul 1999 12:50:22 +1000 Received: from is1 (is1.main.ckpg.in [192.168.2.56]) by mail.main.ckpg.in (8.9.1/8.9.1) with SMTP id MAA04371 for ; Mon, 5 Jul 1999 12:50:21 +1000 From: "Gary Lazarus" To: Subject: wild card functions in select statement? Date: Mon, 5 Jul 1999 12:48:35 +1000 Message-ID: <001d01bec690$e03d5a20$3802a8c0@is1.main.ckpg.in> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_001E_01BEC6E4.B1E96A20" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook 8.5, Build 4.71.2173.0 X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3 Importance: Normal This is a multi-part message in MIME format. ------=_NextPart_000_001E_01BEC6E4.B1E96A20 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi, I'd like to execute a 'select' statement that is built from an HTML form, using wild cards to get a 'smart listing' from my PostgreSQL database. Something like; Select * from esdb where uid='Gary' and pass='*' and temp='*.pdf' This way I could get a complete data extraction of all accounts with a uid of Gary, indifferent to the password, and with a .pdf assigned. Are there available wild cards? Thanks, Gary Lazarus ------=_NextPart_000_001E_01BEC6E4.B1E96A20 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi,

I'd=20 like to execute a 'select' statement that is built from an HTML form, = using wild=20 cards to get a 'smart listing' from my PostgreSQL = database.

Something like; Select * from esdb where uid=3D'Gary' and = pass=3D'*' and=20 temp=3D'*.pdf'

This=20 way I could get a complete data extraction of all accounts with a uid of = Gary,=20 indifferent to the password, and with a .pdf = assigned.

Are=20 there available wild cards?

Thanks,

Gary=20 Lazarus

------=_NextPart_000_001E_01BEC6E4.B1E96A20--