Wildcard in sql

SELECT * FROM table_name WHERE UPPER(col_name) LIKE '%SEARCHED%';
SELECT * FROM table_name WHERE col_name LIKE '%Searched%';  -- Case sensitive

SYMBOL	DESCRIPTION	(SQL)                       EXAMPLE
%	    zero or more characters	                bl%      'bl, black, blue, blob'
_	    a single character	                    h_t      'hot, hat, hit'
[]	    any single character within brackets	h[oa]t   'hot, hat', but NOT 'hit'
^	    any character not in the brackets	    h[^oa]t  'hit', but NOT 'hot, hat'
-	    a range of characters	                c[a-b]t   'cat, cbt'

Similar codes

4 votes221 views1 answer
Adding data to table in sql python
SQL
0 vote237 views1 answer
Sqlalchemy get ids
SQL
1 vote253 views2 answers
Mysql extract number from string
SQL
0 vote207 views1 answer
Hallo
SQL
2 votes244 views2 answers
Mysql write into table
SQL
1 vote215 views1 answer
How to give access to database in postgresql server to another user
SQL
0 vote225 views2 answers
Get all index postgres
SQL
0 vote255 views1 answer
Select * from mysql.proc
SQL
6 votes220 views1 answer
Update left join mysql
SQL
0 vote218 views1 answer
Mysql delete from where like
SQL