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 vote122 views1 answer
What does the -p flag do in mysql cli
SQL
1 vote116 views2 answers
Postgresql truncate cascade restart identity
SQL
0 vote97 views1 answer
Get all employee of salary if more than in sql
SQL
0 vote109 views1 answer
Mysql query problems and solutions
SQL
0 vote100 views1 answer
Sql delete where x or y or z
SQL
0 vote115 views1 answer
Mysql get first 2 characters of string
SQL
1 vote106 views1 answer
Show indices in mysql table
SQL
0 vote102 views1 answer
Select the date 30 days less that the todays date sql request
SQL
0 vote100 views1 answer
Postgresql interview questions
SQL
0 vote122 views1 answer
For row in sql database python loop
SQL