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 vote281 views1 answer
Plpgsql if statement
SQL
0 vote279 views1 answer
SQL isnumeric DB2
SQL
1 vote280 views1 answer
Mysql select update same table
SQL
4 votes287 views1 answer
T-sql get duplicate rows
SQL
2 votes297 views1 answer
Sql server case sensitive search
SQL
0 vote291 views1 answer
Linebreak sql
SQL
0 vote302 views1 answer
Oracle drop type
SQL
8 votes326 views6 answers
Insert command in sql
SQL
1 vote291 views3 answers
Drop unique key constraint in sql server
SQL
5 votes295 views1 answer
Sort order on two columns sql
SQL