"P Kishor" <[EMAIL PROTECTED]> wrote: > On 3/8/07, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > [EMAIL PROTECTED] wrote: > > > If I want to do "SELECT * FROM table WHERE field = value", > > > how can I do this matching text only and not case? > > > > > > > SELECT * FROM table > > WHERE field COLLATE nocase = value; > > > ahhh, I didn't know this could be done at SELECT time. I thought this > had to be defined at CREATE TABLE time. Thanks for the clarification. > > Once again, however, it perplexes me how one could have found this out > from the existing docs. The more that can be found from existing docs, > the less folks will have to rely on the mailing list for help > (hopefully). >
It's a new feature, introduced with 3.3.13 and still experimental, so undocumented. :-) -- D. Richard Hipp <[EMAIL PROTECTED]> ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
