[SQL๋ฌธ์ œํ’€๊ธฐ - Advent of SQL 2025 ๐ŸŽ…] ์‚ฌ๋ž‘์— ๋Œ€ํ•œ ์˜ํ™” ์ฐพ๊ธฐ

silver's avatar
Nov 30, 2025
[SQL๋ฌธ์ œํ’€๊ธฐ - Advent of SQL 2025 ๐ŸŽ…] ์‚ฌ๋ž‘์— ๋Œ€ํ•œ ์˜ํ™” ์ฐพ๊ธฐ

๋ฌธ์ œ

MySQL

๋‚ด๊ฐ€ ์ž‘์„ฑํ•œ ์ •๋‹ต

: ์ด์ „์— Leetcode์—์„œ ํ’€์—ˆ๋˜ mysql๋ฌธ์ œ์—์„œ๋Š” like๋ฅผ ์‚ฌ์šฉํ•ด๋„ ๋Œ€์†Œ๋ฌธ์ž๋ฅผ ๋”ฐ๋กœ ๊ตฌ๋ถ„ํ•˜๊ธฐ ์œ„ํ•ด binary๋ฅผ ์‚ฌ์šฉํ•ด์•ผํ–ˆ์œผ๋‚˜ ์—ฌ๊ธฐ์„œ๋Š” ๊ทธ๋ƒฅ ๊ตฌ๋ถ„์ด ๋˜์—ˆ๋‹ค. ๋ฌผ๋ก  binary๋ฅผ ์‚ฌ์šฉํ•ด๋„ ๋˜์—ˆ๋‹ค
select title, year, rotten_tomatoes from movies where title like '%Love%' or title like '%love%' order by 3 desc, 2 desc; select title, year, rotten_tomatoes from movies where binary title like '%Love%' or binary title like '%love%' order by 3 desc, 2 desc;

SQLite

๋‚ด๊ฐ€ ์ž‘์„ฑํ•œ ์ •๋‹ต

select title, year, rotten_tomatoes from movies where title like '%Love%' or title like '%love%' order by 3 desc, 2 desc;

PostgreSQL

๋‚ด๊ฐ€ ์ž‘์„ฑํ•œ ์ •๋‹ต

select title, year, rotten_tomatoes from movies where title like '%Love%' or title like '%love%' order by 3 desc, 2 desc;
Share article

silver