[SQL] LEFT, REPLACE, SUBSTRING
ยท
๐Ÿ›ข๏ธ Database
PostgreSQL ๋ฌธ๋ฒ• ์˜ˆ์ œ Table - Ticker information ๋”๋ณด๊ธฐ NOTE https://www.postgresql.org/docs/current/functions-string.html 9.4. String Functions and Operators 9.4. String Functions and Operators 9.4.1. format This section describes functions and operators for examining and manipulating string values. Strings in … www.postgresql.org ๋ฌธ๋ฒ•์— ์•ž์„œ PostgreSQL์— ์‚ฌ์šฉ ๋˜๋Š” ๋ฌธ์ž์—ด ํ•จ์ˆ˜์™€ ์—ฐ์‚ฐ์ž ์‚ฌ์šฉ์‹œ SQL์€ ์‰ผํ‘œ๊ฐ€ ์•„๋‹Œ ํ‚ค์›Œ๋“œ๋ฅผ ์‚ฌ์šฉํ•˜์—ฌ ์ธ์ˆ˜๋ฅผ ๊ตฌ๋ถ„ํ•˜๋Š” ..
[SQL] LIKE
ยท
๐Ÿ›ข๏ธ Database
https://www.postgresql.org/docs/current/functions-matching.html#FUNCTIONS-SIMILARTO-REGEXP 9.7. Pattern Matching 9.7. Pattern Matching 9.7.1. LIKE 9.7.2. SIMILAR TO Regular Expressions 9.7.3. POSIX Regular Expressions There are three separate approaches to pattern … www.postgresql.org [Postgre Document] 9.7.1. LIKE LIKE ์—ฐ์‚ฐ์ž๋Š” SQL ํ‘œ์ค€์— ๋”ฐ๋ผ ํŒจํ„ด์„ ๊ธฐ๋ฐ˜์œผ๋กœ ๋ฌธ์ž์—ด์„ ๋น„๊ตํ•˜๊ธฐ ์œ„ํ•ด ์‚ฌ์šฉ๋ฉ๋‹ˆ๋‹ค. LIKE ํŒจํ„ด์€ ๋‹ค์Œ๊ณผ ๊ฐ™์€ ๊ตฌ๋ฌธ์œผ๋กœ ์‚ฌ์šฉ๋  ์ˆ˜ ์žˆ์Šต๋‹ˆ๋‹ค..
๋‹คํ–ˆ๋‹ค
'Like' ํƒœ๊ทธ์˜ ๊ธ€ ๋ชฉ๋ก