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 votes330 views1 answer
Install postgresql centos 5
SQL
1 vote267 views1 answer
Mysql average of multiple columns
SQL
0 vote288 views1 answer
Rename view mysql
SQL
0 vote294 views1 answer
Open postgresql.conf in centos
SQL
0 vote325 views1 answer
New rails app with mysql
SQL
18 votes291 views4 answers
Uninstall mysql ubuntu 18.04
SQL
0 vote300 views2 answers
Sql count number of rows after group by
SQL
0 vote338 views1 answer
Pgadmin postgres ERROR: database is being accessed by other users
SQL
0 vote299 views1 answer
How to start my sql server on mac
SQL
1 vote310 views1 answer
Mysql curdate between two dates
SQL