교육
채용
코딩테스트
인증시험로그인기업서비스

편집 기록

편집 기록
  • 프로필 편집요청빌런님의 편집
    날짜2017.08.22

    oracle을 mysql로 바꾸고 싶어요 

    select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 1) as rs from parking_lot where old_address like '%') a where rs is not null group by rs;


select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 2) as rs from parking_lot where old_address like '%대전광역시%') a where rs is not null group by rs;


select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 3) as rs from parking_lot where old_address like '%대전광역시 동구%') a where rs is not null group by rs;

    이렇게 세가지를 mysql로 바꾸고 싶은데 어떻게 하나요

  • 프로필 이 진수님의 편집
    날짜2017.08.21

    oracle을 mysql로 바꾸고 싶어요

    select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 1) as rs from parking_lot where old_address like '%') a where rs is not null group by rs;

    select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 2) as rs from parking_lot where old_address like '%대전광역시%') a where rs is not null group by rs;

    select rs , count(*)as countnum from (select REGEXP_SUBSTR(old_address, '[^ ]+',1, 3) as rs from parking_lot where old_address like '%대전광역시 동구%') a where rs is not null group by rs;

    이렇게 세가지를 mysql로 바꾸고 싶은데 어떻게 하나요