When it comes to home security, the strength and reliability of your door locks matter more than most people realize. UPVC doors are common in modern homes across the UK, and while they offer excellent insulation and style, the locks can become probl...
Hey coders and pizza fans! 👋 In my last blog post, we learned about HTML lists with my top-secret, low-carb, pizza dough recipe. Today, we’re going to explore the powerful combination of JavaScript's .replace() method and regular expressions. And be...
● String length ● String slice() ● String substring() ● String substr() ● String replace() ● String replaceAll() ● String toUpperCase() ● String toLowerCase() ● String concat() String Length:- ● String trim() ● String trimStart() ● String tr...
replace를 이용하여 특정 문자를 다른 문자로 바꾸는 방법 REPLACE 함수는 컬럼 내의 특정 문자를 다른 문자로 바꿀 때 사용한다. replace(바꿀 컬럼, 현재 값, 바꿀 값) ex) '문곡리'라고 되어있는 주소를 '문가리'라고 바뀐 주소명으로 치환해주기 SELECT addr, REPLACE (addr, '문곡리', '문가리') "바뀐주소" FROM food_orders WHERE addr LIKE '%문곡리%' ...
Solving code wars kata problem: replacing vowels with numbers. In this problem, we are required to replace vowels in a given string with some numbers and reverse it if required. Here is the problem: Step 1: Create a function called encode() to replac...
![[sql study note] replace, substring, concat, if, case, cast](https://cdn.hashnode.com/res/hashnode/image/upload/v1709194867103/c4a38575-a31d-4c9a-95dd-179e54b322cd.png)
