ignore single character in SELECT query?

From: jspring(at)gmail(dot)com
To: pgsql-sql(at)postgresql(dot)org
Subject: ignore single character in SELECT query?
Date: 2005-04-13 02:46:03
Message-ID: 1113360363.473080.314360@z14g2000cwz.googlegroups.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Given select criteria "dont" I would like to return rows with values
"don't". Or similarily I want rows with "they're" given input criteria
"theyre".

So basically I want to ignore a single character (the apostrophe
character), anywhere in the middle of my search word, in selecting
results. How can I do this?

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bill Lawrence 2005-04-13 03:46:00 Re: Getting the output of a function used in a where clause
Previous Message Scott Marlowe 2005-04-12 20:42:54 Re: getting count for a specific querry