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 vote348 views1 answer
Mssql dockere
SQL
2 votes330 views2 answers
How to check data type in sql server
SQL
0 vote353 views1 answer
Is there any limit of using joins in single mysql query ?
SQL
50 votes409 views6 answers
Install mysql on ubuntu
SQL
0 vote333 views1 answer
Day of the week sqlite
SQL
3 votes324 views1 answer
Sql server check version
SQL
1 vote349 views3 answers
How to create a table structure from another table in mysql
SQL
0 vote320 views1 answer
Database timezone
SQL
2 votes322 views2 answers
Mysql on duplicate key ignore
SQL
12 votes350 views4 answers
Psql command not found
SQL