Understanding String Methods in JavaScript Strings are one of the most fundamental data types in JavaScript, and they come with a variety of built-in methods that allow developers to manipulate and work with text efficiently. In this blog, we will ex...
I needed to collect messages from different processes which was triggered by a record insertion. To keep things simple and denormalized, this stack overflow gem allows for that. from django.db import models class DBModel(models.Model): @classmet...
Array An array is a special variable, which can hold more than one value. An array can hold many values under a single name, and you can access the values by referring to an index number. Syntax:- const array_name \= [item1, item2, ...]; Example:...
replace를 이용하여 특정 문자를 다른 문자로 바꾸는 방법 REPLACE 함수는 컬럼 내의 특정 문자를 다른 문자로 바꿀 때 사용한다. replace(바꿀 컬럼, 현재 값, 바꿀 값) ex) '문곡리'라고 되어있는 주소를 '문가리'라고 바뀐 주소명으로 치환해주기 SELECT addr, REPLACE (addr, '문곡리', '문가리') "바뀐주소" FROM food_orders WHERE addr LIKE '%문곡리%' ...
Introduction: Arrays are a fundamental data structure in JavaScript, providing a powerful way to store and manipulate collections of elements. When working with arrays, there are scenarios where you need to combine multiple arrays into a single, cohe...
Use the below command to combine 2 excel columns with a seperator.You can apply it on one cell & then drag it to apply the same on the whole column =CONCATENATE(D3,",",E3)
![[sql study note] replace, substring, concat, if, case, cast](https://cdn.hashnode.com/res/hashnode/image/upload/v1709194867103/c4a38575-a31d-4c9a-95dd-179e54b322cd.png)
