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 votes170 views1 answer
Sql server: select column values as comma separated string
SQL
0 vote137 views1 answer
Mysql uuid
SQL
0 vote134 views1 answer
Postgres data location
SQL
0 vote145 views1 answer
Mysql select where field is a value
SQL
0 vote145 views1 answer
Could not assemble any primary key columns for mapped table sqlalchemy
SQL
2 votes145 views1 answer
Express api ith mysql data
SQL
0 vote144 views1 answer
Ubuntu stop mysql from starting on boot
SQL
0 vote146 views1 answer
Get rows from 1 table with other table empty mysql
SQL
2 votes196 views1 answer
Flask sqlalchemy boolean field
SQL
0 vote138 views1 answer
Forcefully delete a row in mysql which has references
SQL