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

5 votes393 views2 answers
How to ascending order in sql
SQL
-1 vote364 views2 answers
Installing mysql on centos 7
SQL
0 vote344 views1 answer
Sql order by number not ordered
SQL
0 vote337 views1 answer
List mysql tables and views
SQL
8 votes393 views1 answer
See all users mysql
SQL
1 vote296 views1 answer
Postgres grant read only access to database
SQL
0 vote361 views1 answer
Closure in sql
SQL
1 vote345 views1 answer
Spring postgresql reset auto increment to 0
SQL
2 votes306 views1 answer
Sql select in list
SQL
0 vote356 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL