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

12 votes278 views3 answers
Duplicate a column in sql
SQL
4 votes322 views1 answer
Sql select limit range
SQL
0 vote310 views1 answer
Psotgres multiple values
SQL
0 vote285 views1 answer
Sql get month and year from date
SQL
3 votes304 views2 answers
How to list columns for particular tables in postgresql
SQL
0 vote296 views1 answer
Mysql query to add hours to column in table
SQL
0 vote309 views1 answer
Oracle running queries
SQL
0 vote295 views1 answer
Sqlplus change user
SQL
6 votes323 views3 answers
Rename column ORACLE
SQL
2 votes349 views1 answer
Sql compare strings
SQL