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

3 votes126 views1 answer
Postgresql db owner change
SQL
0 vote76 views1 answer
Now() -1 mysql
SQL
0 vote141 views1 answer
How to do a function to return row type from a table in pl/sql
SQL
7 votes113 views1 answer
Forge server hosting
SQL
1 vote121 views1 answer
Group_concat order by
SQL
0 vote121 views1 answer
Mysql to get column name in database
SQL
0 vote137 views1 answer
Convert multiple columns to ROws in sql server
SQL
0 vote115 views1 answer
Mysql drop multiple tables at once
SQL
0 vote112 views1 answer
Error in connection_import_file(conn@ptr, name, value, sep, eol, skip) : RS_sqlite_import: test.csv line 2 expected 11 columns of data but found 1
SQL
0 vote115 views1 answer
Resulting Query
SQL