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 vote287 views1 answer
Oracle explain plan
SQL
0 vote319 views1 answer
Flask sqlalchemy. commit does not save changes
SQL
0 vote301 views1 answer
Mysql subtract month from timestamp
SQL
0 vote328 views1 answer
Implode in sql query
SQL
20 votes290 views4 answers
Reset auto increment in MySQL
SQL
-1 vote290 views3 answers
Create temp table in sql
SQL
0 vote313 views1 answer
How to get nth number in sql
SQL
0 vote300 views1 answer
Qt qsql check if table exist
SQL
0 vote285 views1 answer
Sql select first and last record of each group
SQL
-1 vote298 views1 answer
Mysql order by on condition
SQL