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 vote152 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote273 views2 answers
Mysql insert rows to another database
SQL
0 vote134 views1 answer
Distinct data types in a table sql query
SQL
0 vote140 views1 answer
Sql case sttement with set
SQL
5 votes184 views4 answers
Mysql on duplicate key update
SQL
0 vote207 views1 answer
Select milliseconds mysql
SQL
-1 vote190 views1 answer
Difference berween database and data base management system
SQL
-1 vote147 views1 answer
Concat two columns in sql server
SQL
3 votes172 views1 answer
Apex set debug level
SQL
0 vote134 views2 answers
Postgresql change user role grant
SQL