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 vote257 views1 answer
How convert into in in sql query
SQL
3 votes278 views3 answers
Mysql auto increment after delete
SQL
2 votes262 views1 answer
Mysql clear screen
SQL
0 vote241 views1 answer
Sql query with date
SQL
3 votes273 views2 answers
Oracle privileges users
SQL
2 votes278 views1 answer
Sql find not in list
SQL
1 vote259 views1 answer
Import sql file mysql commadn line
SQL
6 votes267 views1 answer
Oracle list primary key
SQL
0 vote258 views1 answer
Sql server insert inner join
SQL
0 vote268 views2 answers
Call to undefined function mysqli_fetch_all()
SQL