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

2 votes213 views1 answer
How to select from mssql
SQL
1 vote478 views1 answer
Mysql event last execution
SQL
0 vote152 views1 answer
Groupby sort sql hive
SQL
0 vote160 views1 answer
Sql values not in another table
SQL
0 vote145 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote144 views1 answer
Vbscript create ADODB.Connection
SQL
0 vote142 views2 answers
Functions with parameters SQL
SQL
5 votes185 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
10 votes166 views1 answer
How to import database in mysql by cmd
SQL
0 vote179 views1 answer
Sql order by number not ordered
SQL