Postgres Pro
Downloads
Home   >   mailing lists

Re: ignore single character in SELECT query? - Mailing list pgsql-sql

From Greg Stark
Subject Re: ignore single character in SELECT query?
Date
Msg-id 87oecjjmvr.fsf@stark.xeocode.com
Whole thread Raw
In response to ignore single character in SELECT query?  (jspring@gmail.com)
List pgsql-sql
Tree view 
jspring@gmail.com writes:

> 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?

WHERE replace(name,'''','') like '%dont%'

Beware of quoting issues if "dont" is coming from user supplied inputs.

-- 
greg

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: max question
Next
From: "Dinesh Pandey"
Date:
Subject: Re: ignore single character in SELECT query?