Answers for "sql where name starts with"

SQL
2

sql print all names that start with a given letter

select employee_name 
from employees
where employee_name LIKE 'A%' OR employee_name LIKE 'B%'
order by employee_name
Posted by: Guest on June-13-2020
0

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

Code answers related to "sql where name starts with"

Code answers related to "SQL"

Browse Popular Code Answers by Language