[SQL] 이름에 el이 들어가는 동물 찾기
by Roel Downey728x90
반응형
이름에 el이 들어가는 동물 찾기
문제
풀이
-- 코드를 입력하세요 SELECT animal_id, name from animal_ins where name like("%el%") and animal_type = "dog" order by name;
728x90
반응형
블로그의 정보
What doing?
Roel Downey활동하기
What doing?Roel Downey 님의 블로그입니다.
![[SQL] 오랜 기간 보호한 동물(2) 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2Fo5sHJ%2Fbtrn6Pu0Rs1%2FAAAAAAAAAAAAAAAAAAAAAI9e805Q1tfAIPUinK6s3lZXso_fWGqvPj1kDR7fz1uD%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1764514799%26allow_ip%3D%26allow_referer%3D%26signature%3DwrZ8Iblyoze2jrK375MvQrF2%252BTE%253D)
![[SQL] DATETIME에서 DATE로 형 변환 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FewpHky%2Fbtrn55SC3Ke%2FAAAAAAAAAAAAAAAAAAAAAKPGOq3zXNZfxIEy79n13j2ZPqJ3u6wZ0S2jlnN1x2Ft%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1764514799%26allow_ip%3D%26allow_referer%3D%26signature%3DZ5XJdJnay7erR5Xs%252F4c6IQnFuuA%253D)
![[SQL] 있었는데요 없었습니다. 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FOSc7F%2FbtqDwe9aHDF%2FAAAAAAAAAAAAAAAAAAAAAGTXugShdglR1sTHGGme4d7v8Um5XoQBOvM1kv-JzNKk%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1764514799%26allow_ip%3D%26allow_referer%3D%26signature%3DKBXlRMbFUL0tRF5d348PAq01ghI%253D)
![[SQL] 없어진 기록 찾기 글의 미리보기 사진](https://img1.daumcdn.net/thumb/R100x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdna%2FAW7q9%2FbtqDxvoJXLl%2FAAAAAAAAAAAAAAAAAAAAANm4gQ7eanPgfGn-NOXgKB57r-pXU8tIa7TI91D-M8YY%2Fimg.png%3Fcredential%3DyqXZFxpELC7KVnFOS48ylbz2pIh7yKj8%26expires%3D1764514799%26allow_ip%3D%26allow_referer%3D%26signature%3DTjNIBzi%252BKiPfs3qVq9GD7O7BXvk%253D)