DB 2일차 3()

like 

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst	
WHERE 
	`name` LIKE '%수%' 
	AND `name` not LIKE'%수' ;

not

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst	
WHERE 
	not student_year = 3;

 

in /*원하는것만 들고오자*/

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst	
WHERE 
	student_year IN(1,2);

1,2 학년 만

not in /*원하는것만 들고오자*/

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst	
WHERE 
	student_year not IN(1,2);

between

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst
	
WHERE
	score BETWEEN 80 AND 90;

not between

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst
	
WHERE
	score not BETWEEN 80 AND 90;

 

is null

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst
	
WHERE
	`name` IS NULL

in not null

SELECT
	id,
	`name`,
	student_year,
	score
FROM
	student_mst
	
WHERE
	`name` IS not NULL;

 

소스트리 올릴때

기존에 있던거 삭제하고 올려라