Hi, By default the LIKE criteria of MonetDB returns results by matching the exact case of the search word (MonetDB Jan 2014 SP1 Mac). How to make the LIKE criteria to do a case insensitive search by default?? (Something like the BINARY keyword that does case sensitive search in MySQL??) I don't wish to add a workaround like "LOWER(column) like LOWER(searchword)" here.. Any help much appreciated. Thanks in advance. Thanks & Regards, Vijayakrishna.P. Mobile : (+91) 9500402305.
On Mon, Mar 23, 2015 at 11:34:59AM +0530, Vijay Krishna wrote:
Hi,
By default the LIKE criteria of MonetDB returns results by matching the exact case of the search word (MonetDB Jan 2014 SP1 Mac).
How to make the LIKE criteria to do a case insensitive search by default?? (Something like the BINARY keyword that does case sensitive search in MySQL??)
I don't wish to add a workaround like "LOWER(column) like LOWER (searchword)" here..
Any help much appreciated. Thanks in advance.
Vijay MonetDB has ilike for this. i for ignore case sensitivity. Niels
Thanks & Regards,
Vijayakrishna.P. Mobile : (+91) 9500402305.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
So its, select * from table where column ILIKE 'data';
Thats great.
Thanks a lot Neils.
Thanks & Regards,
Vijayakrishna.P.
Mobile : (+91) 9500402305.
On Mon, Mar 23, 2015 at 12:30 PM, Niels Nes
On Mon, Mar 23, 2015 at 11:34:59AM +0530, Vijay Krishna wrote:
Hi,
By default the LIKE criteria of MonetDB returns results by matching the exact case of the search word (MonetDB Jan 2014 SP1 Mac).
How to make the LIKE criteria to do a case insensitive search by default?? (Something like the BINARY keyword that does case sensitive search in MySQL??)
I don't wish to add a workaround like "LOWER(column) like LOWER (searchword)" here..
Any help much appreciated. Thanks in advance.
Vijay
MonetDB has ilike for this. i for ignore case sensitivity.
Niels
Thanks & Regards,
Vijayakrishna.P. Mobile : (+91) 9500402305.
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
-- Niels Nes, Manager ITF, Centrum Wiskunde & Informatica (CWI) Science Park 123, 1098 XG Amsterdam, The Netherlands room L3.14, phone ++31 20 592-4098 sip:4098@sip.cwi.nl url: https://www.cwi.nl/people/niels e-mail: Niels.Nes@cwi.nl
_______________________________________________ users-list mailing list users-list@monetdb.org https://www.monetdb.org/mailman/listinfo/users-list
participants (2)
-
Niels Nes -
Vijay Krishna