[EMAIL PROTECTED] wrote: > > Hello Everybody ! > > I'm looking for a caseless select with like ?????? > > Because like is casesensitiv by default, my application does: > > mysearch = upper(what_i_want) > Select * from adresses where upper(name) like '%?mysearch%'
I assume like '%?MYSEARCH%' > > Is it possible to do an caseless search with like ???? No > If not > Is it possible to create an index for upper(name) ???? One can create index for dbfunction as described here: http://dev.mysql.com/doc/maxdb/en/6d/117c4dd14811d2a97400a0c9449261/frameset.htm --> 7.5.01, create a dbfunction myupper (or the like) doing the upper and then create the index for myupper > If not > How to speed up the select ??? (about 300000 adresses) If you use like '%?...', no index can be used to prepare a range of (index/key) values to be checked. Therefore in any case a scan has to be performed. No speeding up is possible in such case. Elke SAP Labs Berlin > Any help welcomed > > Best regards > > Albert > > ''''' > ''''''''' > (0 0) > +---------oOO-------(_)-------------------+ > | Tel: 0541/5841-868 | > | Fax: 0541/5841-869 | > | Mail: mailto:[EMAIL PROTECTED] | > | Internet: http://www.piepenbrock.de | > +-------------------------------oOO-------+ > |__|__| > || || > ooO Ooo > -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
