From: Carl Flansbaum <carl@planetcpub.com>
To: pgsql-sql@postgresql.org
Subject: Techniques for quickly finding words in a phrase...
Date: Tue, 15 Feb 2000 09:08:46 -0800
Message-ID: <NCBBJGOOFJCJNAOHJECCGEFLFDAA.carl@planetcpub.com> (raw)
Hello,
Ok, can anyone help with the following...
I'm also looking to write a SQL query to find a specific string in a target
of words.
the field contains values like 1234 2456 1234a etc.
The problem is that the string must be exact, so while using
WHERE foo ~ '1234';
or
WHERE foo LIKE '1234';
or
WHERE foo ~* '[[:<:]]1234';
will work, it also brings up results with the 1234a value in the field.
I've tried a wide variety of pattern matching with no luck.
any advice?
thanks
carl
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: carl@planetcpub.com
Subject: Re: Techniques for quickly finding words in a phrase...
In-Reply-To: <NCBBJGOOFJCJNAOHJECCGEFLFDAA.carl@planetcpub.com>
References: <NCBBJGOOFJCJNAOHJECCGEFLFDAA.carl@planetcpub.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox