Received: from icebox.venux.net (icebox.venux.net [216.120.166.10]) by hub.org (8.10.1/8.10.1) with ESMTP id e63JkPS82536 for ; Mon, 3 Jul 2000 15:46:26 -0400 (EDT) Received: from doot (usr1-ip016-grr.wmis.net [209.176.193.66]) by icebox.venux.net (Postfix) with SMTP id 53B1126202; Mon, 3 Jul 2000 15:53:21 -0400 (EDT) Message-ID: <012e01bfe527$61736160$0300000a@doot.org> From: "Mitch Vincent" To: "Joern Muehlencord" , "gpsql-sql" References: <12843.000626@uni-paderborn.de> Subject: Re: case insensitive search Date: Mon, 3 Jul 2000 15:46:27 -0400 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2615.200 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2615.200 X-Archive-Number: 200007/20 SELECT whatever FROM wherever WHERE lower(yourfield) = 'this'; You can do it with a case inseneitive regex search but they can't use indexes and can become very slow on large tables.. SELECT whatever FROM wherever WHERE yourfield ~* 'this'; lower() does leak a bit of memory from what I've heard on the list but I'm sure someone is working on it.. -Mitch ----- Original Message ----- From: Joern Muehlencord To: gpsql-sql Sent: Monday, June 26, 2000 2:14 PM Subject: [SQL] case insensitive search > Hello together, > > how can I handle case insensitive search in a table? > > > > -- > Linux is like wigwam - no windows, no gates, apache inside. > In diesem Sinne > Joern > > >