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 vote365 views1 answer
Rename constraint postgresql
SQL
3 votes350 views1 answer
How to find names includes in sql
SQL
0 vote345 views2 answers
Raise notice in postgresql function
SQL
5 votes327 views2 answers
Update all rows mysql
SQL
0 vote345 views1 answer
Connecting to my cloud sql server with c#
SQL
0 vote390 views2 answers
Mysql cast to varchar
SQL
1 vote344 views2 answers
Pad zero sql server
SQL
0 vote381 views1 answer
Postgresql custom order by
SQL
3 votes344 views1 answer
Select sequence oracle
SQL
0 vote332 views1 answer
Reset postgresql password windows
SQL