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 vote225 views2 answers
Mysql on update current_timestamp
SQL
0 vote237 views1 answer
How to check which table has data in mysql
SQL
4 votes235 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote221 views1 answer
RowDataPacket
SQL
0 vote247 views2 answers
Mysql dump database tables only
SQL
20 votes223 views1 answer
Sql change column types
SQL
8 votes246 views2 answers
Mysql grant all privileges to user from any host
SQL
0 vote232 views1 answer
Mysql get date diff in months
SQL
0 vote213 views1 answer
Parsing float to int in mysql
SQL
0 vote227 views1 answer
Oracle synonym procedure dblink
SQL