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

1 vote301 views1 answer
Mysql sort by date column
SQL
5 votes336 views1 answer
Mysql add user with all privileges
SQL
3 votes332 views3 answers
Stop mysql ubuntu
SQL
0 vote330 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
1 vote315 views1 answer
Declare table variable
SQL
0 vote304 views1 answer
How to put 0 or 000 depending IDCustomer length in sql server
SQL
0 vote328 views1 answer
Table user postgres
SQL
1 vote281 views1 answer
Update from select join
SQL
0 vote305 views1 answer
Sql convert datetime to year
SQL
1 vote325 views1 answer
Oracle sql first day of year
SQL