[MYSQL] #05. "성+이름"으로 저장돼있을 때 특정 '성씨'인 사람을 select 하기

-- select 'a particular family name'
SELECT *
FROM your_table
WHERE SUBSTRING(name_attribute, 1, 1) = 'family name';


-- example
SELECT *
FROM customer
WHERE SUBSTRING(customer_name, 1, 1) = '이';