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

13 votes220 views2 answers
Get date from now() mysql
SQL
0 vote233 views1 answer
Repeatable read trong sql server
SQL
0 vote221 views1 answer
Createdb with postgresql on ubuntu
SQL
0 vote170 views1 answer
Hangfire clean script
SQL
12 votes255 views4 answers
How to drop all tables in postgresql
SQL
0 vote223 views1 answer
Update database collation in postgresql
SQL
1 vote212 views1 answer
Sql get missing id
SQL
0 vote230 views1 answer
Create table with primary key and foreign key in sql server
SQL
9 votes245 views3 answers
Postgres make sql dump
SQL
46 votes230 views4 answers
Create column sql
SQL