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 vote162 views1 answer
How to use a trigger to validate input data
SQL
1 vote186 views1 answer
Add current timestamp in mysql
SQL
1 vote189 views1 answer
How to convert number to hours and minutes in oracle sql
SQL
3 votes158 views1 answer
Mysql CURRENT_TIMESTAMP()
SQL
8 votes173 views5 answers
Alter table add column with default value
SQL
1 vote170 views1 answer
Oracle sql listagg
SQL
0 vote169 views1 answer
Sql create text column limited values
SQL
1 vote189 views1 answer
Mysql select and count left join
SQL
1 vote172 views1 answer
Mamp mysql path mac
SQL
0 vote173 views1 answer
ORA-13717
SQL