Sql string contains case sensitive

SELECT DISTINCT COL_NAME FROM myTable WHERE UPPER(COL_NAME) LIKE UPPER('%PriceOrder%')
# or
SELECT DISTINCT COL_NAME FROM myTable WHERE LOWER(COL_NAME) LIKE LOWER('%PriceOrder%')

Source: stackoverflow.com

Similar codes

2 votes322 views1 answer
Removing view
SQL
3 votes462 views9 answers
Linq to sql converter online
SQL
5 votes296 views1 answer
Mysql select greater than yesterday
SQL
20 votes362 views4 answers
How to find average in sql
SQL
0 vote305 views1 answer
Psql check if value in array
SQL
6 votes302 views5 answers
Get current date sql
SQL
0 vote310 views1 answer
Oracle synonym procedure
SQL
0 vote315 views1 answer
Mysql database hyphen
SQL
1 vote319 views1 answer
Sql where last 12 months
SQL
0 vote313 views1 answer
Copied text from internet not inserting in mysql
SQL