Answers for "sql ends with string"

SQL
0

sql ends with string

-- 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
Posted by: Guest on April-17-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language