Case insensitive searching in Oracle
The default behaviour of LIKE and the other comparison operators, = etc is case-sensitive. Is it possible make them case-insensitive? 7 Answers 7
The default behaviour of LIKE and the other comparison operators, = etc is case-sensitive. Is it possible make them case-insensitive? 7 Answers 7
Which one of the following queries is faster (LIKE vs CONTAINS)? SELECT * FROM table WHERE Column LIKE ‘%test%’; or SELECT * FROM table WHERE Contains(Column, “test”); 4 Answers 4
I am trying to filter items with a stored procedure using like. The column is a varchar(15). The items I am trying to filter have square brackets in the name. For example: WC[R]S123456. If I do a LIKE ‘WC[R]S123456’ it will not return anything. I found some information on using the ESCAPE keyword with LIKE … Read more
When using SQL, are there any benefits of using = in a WHERE clause instead of LIKE? Without any special operators, LIKE and = are the same, right? 16 Answers 16
This question already has answers here: Is there a combination of “LIKE” and “IN” in SQL? (25 answers) Closed 8 years ago. Is it possible to combine LIKE and IN in a SQL Server-Query? So, that this query SELECT * FROM table WHERE column LIKE IN (‘Text%’, ‘Link%’, ‘Hello%’, ‘%World%’) Finds any of these possible … Read more
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
I have a procedure in SQL that I am trying to turn into Linq: SELECT O.Id, O.Name as Organization FROM Organizations O JOIN OrganizationsHierarchy OH ON O.Id=OH.OrganizationsId where OH.Hierarchy like ‘%/12/%’ The line I am most concerned with is: where OH.Hierarchy like ‘%/12/%’ I have a column that stores the hierarchy like /1/3/12/ for example … 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
I want to query something with SQL’s like query: SELECT * FROM users WHERE name LIKE ‘%m%’ How can I achieve the same in MongoDB? I can’t find an operator for like in the documentation. 4 45