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 vote254 views1 answer
An error occurred while installing mysql2 (0.5.3)
SQL
1 vote291 views2 answers
Duplicate key value violates unique constraint "django_admin_log_pkey"
SQL
0 vote255 views1 answer
Check if table exists oracle
SQL
0 vote254 views1 answer
2020 new year
SQL
4 votes276 views1 answer
Search column by name mysql
SQL
2 votes267 views2 answers
Get all columns from table sql
SQL
18 votes266 views3 answers
'Client does not support authentication protocol requested by server; consider upgrading MySQL client', sqlState: '08004',
SQL
0 vote312 views1 answer
Mysql, how to query the table comments?
SQL
10 votes268 views5 answers
Mysql create user
SQL
14 votes279 views3 answers
Inner join sql oracle
SQL