Re: [GENERAL] Similarity Search with Wildcards

2013-02-28 Thread Ken Tanzer
I'm not sure about the indexing and performance impacts, but I think you could use SUBSTRING with a regex to pull out the client name, and then match on that. SELECT substring('Client Name - Description' FROM '^(.*) [-]'); substring - Client Name On Thu, Feb 28, 2013 at 12:02 AM

Re: [GENERAL] Similarity Search with Wildcards

2013-02-28 Thread Ghislain Hachey
On 02/28/2013 06:12 PM, John R Pierce wrote: > On 2/27/2013 10:35 PM, Ghislain Hachey wrote: >> I have a varchar column with content such as "Client Name - Brief >> Description of Problem" (it's a help desk ticket system). I want to >> generate reports by clients and the only thing I can base my qu

Re: [GENERAL] Similarity Search with Wildcards

2013-02-27 Thread John R Pierce
On 2/27/2013 10:35 PM, Ghislain Hachey wrote: I have a varchar column with content such as "Client Name - Brief Description of Problem" (it's a help desk ticket system). I want to generate reports by clients and the only thing I can base my query on is this column. The client names often contai