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

50 votes194 views6 answers
Sql duplicate rows
SQL
-1 vote143 views1 answer
Mysql select all columns and specific fields as
SQL
0 vote119 views1 answer
Dnsmasq.conf location macos
SQL
1 vote130 views3 answers
Get all tables postgres
SQL
0 vote145 views1 answer
Sql query use select name inside where clause
SQL
16 votes131 views2 answers
Mysql date between two dates
SQL
0 vote126 views1 answer
Postgresql isnull with max
SQL
0 vote141 views1 answer
Change magento database url usimg musql
SQL
0 vote133 views1 answer
Mysql to get column name in database
SQL
0 vote160 views1 answer
Pl sql search in all packages
SQL