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 vote143 views1 answer
Mysql Install Ubuntu with native password
SQL
0 vote161 views1 answer
T sql check active deadlock
SQL
1 vote152 views1 answer
Clear screen command in psql
SQL
0 vote143 views2 answers
Postgresql change user role grant
SQL
0 vote150 views1 answer
Sql drop procedure if exists
SQL
8 votes142 views3 answers
Postgresql connection string c#
SQL
9 votes145 views4 answers
SQL Date Format
SQL
0 vote161 views1 answer
Sql cnvert bit to nvarchar
SQL
0 vote152 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
1 vote148 views1 answer
Window function mysql
SQL