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

0 vote258 views1 answer
Postgresql add not null and not empty constraint
SQL
0 vote293 views1 answer
Mysql sum per week
SQL
0 vote268 views1 answer
Increase speed of like queries postgres
SQL
0 vote232 views1 answer
Best way to create a temp table with same columns and type as a permanent table
SQL
1 vote276 views1 answer
"i_am_a_dummy flag" in MySQL
SQL
13 votes282 views4 answers
Command line mysql import
SQL
6 votes293 views3 answers
Mysql create database utf8
SQL
20 votes284 views6 answers
Creating a table in sql
SQL
0 vote271 views1 answer
Oracle exchange partition
SQL
0 vote290 views1 answer
Oracle list partitions
SQL