Sql ends with string

-- Case insensitive
SELECT * FROM my_table WHERE upper(my_column) LIKE 'SEARCHED %';  -- starts with
SELECT * FROM my_table WHERE upper(my_column) LIKE '% SEARCHED';  -- ends with
SELECT * FROM my_table WHERE upper(my_column) LIKE '%SEARCHED%';  -- contains

Similar codes

2 votes303 views1 answer
Oracle current date without time
SQL
0 vote319 views2 answers
How to login to mysql as normal user in ubuntu
SQL
48 votes356 views3 answers
Psql create database
SQL
0 vote300 views1 answer
Sql server udf performance
SQL
0 vote312 views1 answer
Regex any word except sql
SQL
8 votes274 views2 answers
Alter column name in mssql
SQL
-1 vote299 views3 answers
Psql get last rows
SQL
1 vote326 views1 answer
Write a query to create an empty table from an existing table?
SQL
1 vote299 views1 answer
Can not connect to mysql server
SQL
17 votes307 views3 answers
Postgresql version command
SQL