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 vote236 views1 answer
Do postgresql
SQL
1 vote243 views1 answer
Tsql get beginning of year
SQL
36 votes258 views3 answers
Add column in mysq
SQL
13 votes262 views5 answers
Alter table query sql server change column
SQL
1 vote250 views1 answer
Sqlalchemy order by descending
SQL
0 vote246 views1 answer
Excel export from sql using python
SQL
7 votes233 views2 answers
Mysql db size
SQL
9 votes225 views4 answers
Add primary key to existing table sql
SQL
0 vote227 views1 answer
Mariadb mysql root access denied
SQL
0 vote243 views1 answer
Install squirrel sql ubuntu
SQL