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
Xampp increame mysql speed
SQL
2 votes182 views2 answers
Postgresql date at timezone
SQL
0 vote200 views1 answer
Drop all triggers oracle
SQL
7 votes198 views1 answer
Mysql iif
SQL
0 vote201 views1 answer
Custom row number
SQL
0 vote201 views1 answer
List all indexes postgres
SQL
31 votes204 views4 answers
How to get duplicate records with multiple field in sql
SQL
23 votes188 views6 answers
How to create table in sql
SQL
0 vote260 views1 answer
Sql decimal to 2 places
SQL
3 votes196 views1 answer
Oracle APEX elapsed time
SQL