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

1 vote161 views1 answer
Postgres check blocking
SQL
0 vote189 views1 answer
Why do we need data structure in sql
SQL
0 vote208 views1 answer
Min varias colunas spark sql
SQL
0 vote175 views1 answer
Mysql workbench view
SQL
0 vote166 views1 answer
Prepared statement mysql java delete selected rows
SQL
1 vote166 views2 answers
Sql left characters
SQL
1 vote151 views1 answer
Sql select table header
SQL
0 vote141 views1 answer
How to check oracle index table
SQL
0 vote183 views2 answers
Py sqlite if entry exists
SQL
1 vote185 views1 answer
Dropping a constraint in ms sql
SQL