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 vote179 views2 answers
Nosqlbooster query other collection
SQL
0 vote135 views1 answer
Get all stored procedures in sql server
SQL
1 vote191 views1 answer
How to use db.execute
SQL
0 vote179 views1 answer
Heavy table in mysql
SQL
8 votes217 views1 answer
Racle create auto increment column
SQL
24 votes178 views2 answers
Alter table delete column
SQL
1 vote182 views1 answer
How to subtract from the value of a table in sql
SQL
0 vote177 views2 answers
Sql auto update dupdated_at
SQL
2 votes205 views1 answer
Oracle trace file
SQL
4 votes179 views6 answers
Sql select statement
SQL