<div id="readability-page-1" class="page"><div><h3 id="3월에-태어난-여성-회원-목록-출력하기">3월에 태어난 여성 회원 목록 출력하기</h3>
<img src="https://velog.velcdn.com/images/psj0810/post/28010e65-f6c5-4de4-b897-12b131e04046/image.png"> 
내풀이
<pre><code>SELECT member_id, 
		member_name, 
 gender, 
 date_format(date_of_birth, '%Y-%m-%d') as date_of_birth 
from member_profile 
where date_of_birth like "%-03-%" 
	 and gender like "%W%" 
 and tlno is not null 
order by member_id asc;</code></pre>
<img src="https://velog.velcdn.com/images/psj0810/post/0b41b41c-29d7-46f9-ac8a-c7f4ceaffe61/image.png"> 
<img src="https://velog.velcdn.com/images/psj0810/post/5e1bfffa-e747-4098-9192-3faedccfc824/image.png"></div></div>

psj.log

3월에 태어난 여성 회원 목록 출력하기
내풀이
SELECT  member_id, 
        member_name, 
        gender, 
        date_format(date_of_birth, '%Y-%m-%d') as date_of_birth 
from member_profile 
where date_of_birth like "%-03-%" 
      and gender like "%W%" 
      and tlno is not null 
order by member_id asc;

(select) is not null, like, date_format

댓글