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

1 vote294 views1 answer
Mysql alter decimal precision
SQL
2 votes278 views1 answer
Get first 2 letter in sql
SQL
0 vote260 views1 answer
Myswql show full processlist
SQL
11 votes249 views1 answer
Reset identity sql server
SQL
0 vote266 views1 answer
Phpmyadmin mysql conflict
SQL
0 vote283 views1 answer
Mysql page segment
SQL
0 vote291 views1 answer
PSQL use LIKE with timestamps
SQL
0 vote293 views1 answer
Convert uniqueidentifier to varchar in sql
SQL
2 votes309 views2 answers
Sql lag
SQL
0 vote220 views1 answer
Testing sql queries
SQL