Sql string starts with

-- 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

0 vote223 views1 answer
Where to find pg_hba.conf in ubuntu
SQL
6 votes192 views5 answers
Mysql get last insert id
SQL
3 votes199 views1 answer
Oracle list invalid password ORA-01017
SQL
0 vote205 views1 answer
Sql script to remove default from column
SQL
0 vote182 views1 answer
Sql constarint
SQL
3 votes215 views2 answers
WhereIn SQL
SQL
0 vote149 views1 answer
'0000-00-00' for column '
SQL
0 vote173 views1 answer
Count the table indatabase
SQL
0 vote255 views1 answer
Sql count matching group by
SQL
0 vote183 views1 answer
Join creating duplicate columns sqllite
SQL