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 vote194 views1 answer
Postgres : ERROR: division by zero
SQL
1 vote181 views2 answers
T-sql random number for each row
SQL
1 vote361 views1 answer
Athena query timestamp greater than
SQL
1 vote180 views1 answer
Mysql server does not start mac
SQL
1 vote212 views1 answer
Sql server if exists update else insert
SQL
0 vote226 views1 answer
Postgresql alter table sequence
SQL
2 votes186 views1 answer
Oracle log files
SQL
0 vote201 views1 answer
Search starting with mysql
SQL
1 vote195 views1 answer
Lpad function in sql oracle
SQL
0 vote207 views1 answer
What does leave do in mysql
SQL