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 vote169 views2 answers
How to see table associated with a schema in sql
SQL
8 votes149 views6 answers
Sql insert
SQL
0 vote180 views1 answer
Select count concat string sql server
SQL
1 vote174 views1 answer
Top 10 rows in mysql
SQL
0 vote146 views1 answer
Oracle archivelog usage
SQL
0 vote158 views1 answer
How to set all the time serveroutput on in oracle sql developer
SQL
0 vote150 views1 answer
Mysql count with two joins
SQL
2 votes171 views2 answers
Mysql write into table
SQL
0 vote153 views1 answer
Mysql query problems and solutions
SQL
1 vote149 views1 answer
Oracle apex prevent initial load
SQL