Case Insenstive Queries

Anon

Does anyone have an example of a case insensitive SQL Select Statement? I'm looking for something like...

$searchstr = "%" . $name . "%";

SELECT * FROM vendor
WHERE vendor_name LIKE $searchstr;

Where $name is provide via user input. I just want to return all of the instances, regardless what the the user inputs as far as case goes. I could just store it in my DB as all upper or all lower case, but I'd rather not do that.

Thanks,
Steven Behnke

Anon

Are you using MySQL, because I just tried typing a query where my like clause was in all caps and it returned all rows that had the word regardless of case. I think MySQL will match regardless of case

Anon

No, I'm actually using Postgresql. I'm fairly certain that you can do it with a subquery within a select statement, but I haven't the faintest how.

-Stevem

Anon

I think u can use soundex() function in postgres. I use mysql so can't really help you. Read documentation, you'll find your answer.

Hamster.

Anon

It's probably just a mite late, but try this:

"select * from table where upper(field) like upper ('$variable');"

-Ben

Anon

It may have been too late for him, but it was at the right time for me!

(I knew that was what I wanted to do but wasn't sure of the syntax).

So cheers.

andy.

Anon

try " something ILIKE somethingelse "

"...The keyword ILIKE can be used instead of LIKE to make the match case insensitive according to the active locale..."