upper(lastname) like upper(<dtml-sqlvar lastname type=string>)
* Don't use LIKE without any regular expression
* Use ILIKE instead of UPPER(...) = UPPER(...) since it's usually faster
(I've "proven" this for PostgreSQL at least)
* Fastest method is always to use an index and you can write an index
based on the UPPER() of a column. I've done this for a postcode table
and sped up my queries by more than 10 times.
On 06/09/07, *Jaroslav Lukesh* < [EMAIL PROTECTED]
<mailto:[EMAIL PROTECTED]>> wrote:
Use MS-SQL or Sybase :o)
----- Original Message -----
From: "onsombal" <[EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>>
>
> is there an easy way to make the following ZSQL query
case-insensitive?
>
> select * from clients
> <dtml-sqlgroup where>
> <dtml-sqltest firstname op="like" type="string" optional>
> <dtml-or>
> <dtml-sqltest lastname op="like" type="string" optional>
> <dtml-or>
> <dtml-sqltest client op="like" type="string" optional>
> </dtml-sqlgroup>
>
_______________________________________________
Zope maillist - [email protected] <mailto:[email protected]>
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev
<http://mail.zope.org/mailman/listinfo/zope-dev> )
------------------------------------------------------------------------
_______________________________________________
Zope maillist - [email protected]
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
--
Peter Bengtsson,
work www.fry-it.com
home www.peterbe.com
hobby www.issuetrackerproduct.com
_______________________________________________
Zope maillist - [email protected]
http://mail.zope.org/mailman/listinfo/zope
** No cross posts or HTML encoding! **
(Related lists -
http://mail.zope.org/mailman/listinfo/zope-announce
http://mail.zope.org/mailman/listinfo/zope-dev )
