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 vote273 views1 answer
Hierarchal database table
SQL
0 vote211 views1 answer
Trigger value from maltiple table to single table mysql
SQL
0 vote224 views1 answer
How to declare variable date in mysql
SQL
1 vote204 views2 answers
Mysql update table from another table
SQL
0 vote235 views1 answer
Python mysql show databases
SQL
4 votes219 views3 answers
How to describe a table in sqlite3
SQL
0 vote212 views1 answer
Sql get month and year from date
SQL
0 vote230 views1 answer
To Create directory
SQL
1 vote245 views2 answers
Mysql extract number from string
SQL
10 votes176 views1 answer
Oracle view dependencies
SQL