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 vote161 views2 answers
Drop tables from local table database postgres
SQL
0 vote131 views1 answer
What are the aggregate function in sql
SQL
0 vote136 views1 answer
MySQL INSERT IGNORE Statement
SQL
2 votes185 views1 answer
How to select from mssql
SQL
0 vote157 views1 answer
How to define a save method in ruby for sqlite3 databases
SQL
0 vote188 views1 answer
Having all mysql
SQL
0 vote127 views1 answer
Get records in sql according to month name and count
SQL
1 vote160 views1 answer
Postgresql datetrunc too slow
SQL
0 vote141 views1 answer
Cast as decimal postgresql
SQL
0 vote147 views1 answer
Oracle flush Shared Pool
SQL