It seems like the only way to do this is to pass the -i parameter in when you initially run less. Does anyone know of some secret hack to make something like this work /something to search for/i 5 Answers 5
I want to select records from sqlite3 database by string matching. But if I use ‘=’ in the where clause, I found that sqlite3 is case sensitive. Can anyone tell me how to use string comparing case-insensitive? 11 Answers 11
I looked around some and didn’t find what I was after so here goes. SELECT * FROM trees WHERE trees.`title` LIKE ‘%elm%’ This works fine, but not if the tree is named Elm or ELM etc… How do I make SQL case insensitive for this wild-card search? I’m using MySQL 5 and Apache. 15 Answers … Read more
Example: > db.stuff.save({“foo”:”bar”}); > db.stuff.find({“foo”:”bar”}).count(); 1 > db.stuff.find({“foo”:”BAR”}).count(); 0 25 Answers 25
In Python, I can compile a regular expression to be case-insensitive using re.compile: >>> s=”TeSt” >>> casesensitive = re.compile(‘test’) >>> ignorecase = re.compile(‘test’, re.IGNORECASE) >>> >>> print casesensitive.match(s) None >>> print ignorecase.match(s) <_sre.SRE_Match object at 0x02F0B608> Is there a way to do the same, but without using re.compile. I can’t find anything like Perl’s i … Read more
I have the following: if (referrer.indexOf(“Ral”) == -1) { … } What I like to do is to make Ral case insensitive, so that it can be RAl, rAl, etc. and still match. Is there a way to say that Ral has to be case-insensitive? 14 Answers 14 Add .toUpperCase() after referrer. This method turns … Read more
Is there any way to write case-insensitive queries in PostgreSQL, E.g. I want that following 3 queries return same result. SELECT id FROM groups where name=”administrator” SELECT id FROM groups where name=”ADMINISTRATOR” SELECT id FROM groups where name=”Administrator” 1Best Answer 11 Use LOWER function to convert the strings to lower case before comparing. Try this: … Read more
How can I do case insensitive string comparison in Python? I would like to encapsulate comparison of a regular strings to a repository string using in a very simple and Pythonic way. I also would like to have ability to look up values in a dict hashed by strings using regular python strings. 12 s … Read more
I’d like to search for an upper case word, for example COPYRIGHT in a file. I tried performing a search like: /copyright/i # Doesn’t work but it doesn’t work. I know that in Perl, if I give the i flag into a regex it will turn the regex into a case-insensitive regex. It seems that … Read more
Is there a way to make the following return true? string title = “ASTRINGTOTEST”; title.Contains(“string”); There doesn’t seem to be an overload that allows me to set the case sensitivity. Currently I UPPERCASE them both, but that’s just silly (by which I am referring to the i18n issues that come with up- and down casing). … Read more
