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 vote136 views1 answer
Python escape mysql
SQL
0 vote139 views1 answer
Set a value by excuting stored procedure
SQL
3 votes201 views1 answer
Mysql group_concat distinct
SQL
4 votes149 views2 answers
What is table in sql
SQL
1 vote137 views1 answer
Sql select contem uma palavra
SQL
2 votes134 views1 answer
Set boolean flasksql
SQL
1 vote143 views1 answer
How to use db.execute
SQL
1 vote190 views2 answers
Truncate table sqlite
SQL
0 vote171 views1 answer
Sql developer format sql
SQL
-1 vote147 views1 answer
Add bool column in sql
SQL