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

5 votes246 views3 answers
Create function in postgresql
SQL
0 vote177 views1 answer
What alter does in db
SQL
7 votes148 views1 answer
Alter table add key sql
SQL
12 votes175 views4 answers
SQL Where
SQL
0 vote193 views1 answer
How to find database collation in postgres
SQL
0 vote188 views1 answer
Oracle procedure teamplate
SQL
4 votes173 views2 answers
Could not find driver (SQL: select * from information_schema.tables where table_schema = pics and table_name = migrations and table_type = 'BASE TABLE')
SQL
20 votes198 views6 answers
Creating a table in sql
SQL
2 votes167 views1 answer
Mysql auto increment jumping
SQL
0 vote183 views3 answers
Mysql delete if not in another table
SQL