Re: Querying for strings that match after prefix

From: Joachim Wieland <joe(at)mcknight(dot)de>
To: badlydrawnbhoy <badlydrawnbhoy(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Querying for strings that match after prefix
Date: 2006-06-02 11:49:28
Message-ID: 20060602114928.GA2576@mcknight.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 02, 2006 at 02:47:22AM -0700, badlydrawnbhoy wrote:
> I need to locate all the entries in a table that match , but only after
> a number of characters have been ignored. I have a table of email
> addresses, and someone else has erroneously entered some addresses
> prefixed with 'mailto:', which I'd like to ignore.

Look here:

http://www.postgresql.org/docs/7.4/interactive/functions-string.html

especially the substring function will help you.

Joachim
PS: You should also consider upgrading to 7.4.13

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Nicholay Ryzhov 2006-06-02 11:50:47 Using postgresql as desktop DB
Previous Message Marin Alonso, David 2006-06-02 11:42:23 Migrate Postgres 7.2 to Postgres 8.1