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

14 votes216 views5 answers
Sql oracle limit
SQL
1 vote200 views1 answer
SQLite order random
SQL
4 votes205 views4 answers
Rollback in sql
SQL
0 vote196 views1 answer
Sql view index
SQL
0 vote199 views1 answer
SQL Server rename foreign key constraint
SQL
-1 vote239 views2 answers
Full join sql
SQL
0 vote209 views2 answers
Many to many flask-sqlalchemy
SQL
1 vote253 views3 answers
Nth highest salary
SQL
1 vote206 views1 answer
How to select rows with no matching entry in another table?
SQL
6 votes190 views5 answers
Get current date sql
SQL