What would be useful here would be a LIKE ANY predicate as is available in PostgreSQL SELECT * FROM tbl WHERE my_col LIKE ANY (ARRAY[‘%val1%’, ‘%val2%’, ‘%val3%’, …]) Unfortunately, that syntax is not available in Oracle. You can expand the quantified comparison predicate using OR, however: SELECT * FROM tbl WHERE my_col LIKE ‘%val1%’ OR … Read more
For a regular expression, you would use: re.match(r’Run.*\.py$’) A quick explanation: . means match any character. * means match any repetition of the previous character (hence .* means any sequence of chars) \ is an escape to escape the explicit dot $ indicates “end of the string”, so we don’t match “Run_foo.py.txt” However, for this … Read more
An index cannot safely be used in this case. A naive implementation would transform this: … WHERE word LIKE ‘search_string%’ into … WHERE word >= ‘search_string’ AND word < ‘search_strinh’ by incrementing the last character of the search string. The greater-than and less-than operators can use an index, where LIKE cannot. Unfortunately, that won’t work … Read more
Mysql supports two variants of case, the one you use in query 2 is less flexible but supports only equality on a single variable. The other version specifies no variable after case and then conditions need not be only equality: select id_tag, case when tag LIKE “%class%” then “class” when tag LIKE “%new%” then “new” … Read more
You can try like this: SELECT * FROM my_table WHERE my_column LIKE ‘%\%%’ ESCAPE ‘\’; Format <like predicate> ::= <match value> [ NOT ] LIKE <pattern> [ ESCAPE <escape character> ] <match value> ::= <character value expression> <pattern> ::= <character value expression> <escape character> ::= <character value expression>
This is the syntax you need: CASE WHEN countries LIKE ‘%’+@selCountry+’%’ THEN ‘national’ ELSE ‘regional’ END Although, as per your original problem, I’d solve it differently, splitting the content of @selcountry int a table form and joining to it.
order by case when name LIKE “%John%” then 1 when name LIKE “%Doe%” then 2 else 3 end
Try using COLLATE Latin1_General_BIN rather than COLLATE Latin1_General_CS_AS
First, the PreparedStatement placeholders (those ? things) are for column values only, not for table names, column names, SQL functions/clauses, etcetera. Better use String#format() instead. Second, you should not quote the placeholders like ‘?’, it would only malform the final query. The PreparedStatement setters already do the quoting (and escaping) job for you. Here’s the … Read more
I would use WHERE columnName LIKE ‘%[%]%’ SQL Server stores string summary statistics for use in estimating the number of rows that will match a LIKE clause. The cardinality estimates can be better and lead to a more appropriate plan when the square bracket syntax is used. The response to this Connect Item states We … Read more