Mysql-157343

SELECT *
from CAR_RENTAL_COMPANY_CAR
where OPTIONS like '%네비게이션%'
order by CAR_ID desc;

LIKE
특정 문자열이 포함 되어 있는가

• '%문자열%'
  ex) "SUB1,문자열,SUB2"
• '%문자열'
  ex) "SUB1,SUB2,문자열"
• '문자열%'
  "문자열,SUB1,SUB2"

ORDER BY
특정 컬럼 기준으로 정렬

• order by col1 desc(내림차순)

• order by col1 arc(오름차순)