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 vote208 views1 answer
Mysql illegal mix of collations for operation 'join'
SQL
0 vote209 views1 answer
Test connection to sql server
SQL
0 vote210 views1 answer
Adding generated time in row mysql workbench
SQL
0 vote200 views1 answer
Mysql database is not starting in xampp
SQL
8 votes197 views2 answers
Mysql query dates between two dates
SQL
0 vote352 views1 answer
Hue hive UploadingTextFiletoHive
SQL
0 vote192 views1 answer
Sql check for null and empty string
SQL
3 votes216 views1 answer
Select table column in sql
SQL
0 vote224 views1 answer
How to see the query of a view in mysql
SQL
1 vote221 views1 answer
Update from select join
SQL