Re: [GENERAL] How does one perform a case-insenstive query on

2007-01-10 Thread Bruce Momjian
This is already an FAQ. --- Steve Atkins wrote: > > On Jan 10, 2007, at 12:18 PM, Erik Jones wrote: > > > [EMAIL PROTECTED] wrote: > >> Hello, > >> > >> Well, the subject line pretty much says it all. If any clarification

Re: [GENERAL] How does one perform a case-insenstive query on test or char fields

2007-01-10 Thread Chad Wagner
On 9 Jan 2007 13:44:32 -0800, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: SELECT * FROM table WHERE thisfield = 'some text'; How would I rewrite this query to search through the table looking at the text in the column "thisfield" for the string "some text" but have it perform a case insensitiv

Re: [GENERAL] How does one perform a case-insenstive query on test

2007-01-10 Thread Steve Atkins
On Jan 10, 2007, at 12:18 PM, Erik Jones wrote: [EMAIL PROTECTED] wrote: Hello, Well, the subject line pretty much says it all. If any clarification is needed, what I want to do is as follows: SELECT * FROM table WHERE thisfield = 'some text'; How would I rewrite this query to search throu

Re: [GENERAL] How does one perform a case-insenstive query on test

2007-01-10 Thread Erik Jones
[EMAIL PROTECTED] wrote: Hello, Well, the subject line pretty much says it all. If any clarification is needed, what I want to do is as follows: SELECT * FROM table WHERE thisfield = 'some text'; How would I rewrite this query to search through the table looking at the text in the column "thi

[GENERAL] How does one perform a case-insenstive query on test or char fields

2007-01-10 Thread af300wsm
Hello, Well, the subject line pretty much says it all. If any clarification is needed, what I want to do is as follows: SELECT * FROM table WHERE thisfield = 'some text'; How would I rewrite this query to search through the table looking at the text in the column "thisfield" for the string "som