Re: [PHP] Case Insensitive Searching?
От
Bruno Wolff III
Тема
Re: [PHP] Case Insensitive Searching?
Дата
Msg-id
20030525135630.GB1057@wolff.to
Ответ на
Case Insensitive Searching? (Ben Schneider)
Список
On Fri, May 23, 2003 at 13:24:36 -0700, Ben Schneider wrote: > > So the question is, how do I perform a case insensitive search? Is there a > DB setting I can set to ignore the case? If you were using "like", you can use "ilike" instead. There is also a case insensitive version of the regular expression pattern matching operator. In some cases you may want to use the "lower" function to get the data in just one case before doing a comparison. Without seeing how you are doing your searches now it is hard to provide specifics on what to do to make them case insensitive.
В списке pgsql-novice по дате отправления