Question: I need to update the below dates for multiple records in a table. Each record has a unique Id call object\_id. I have used the below SQL to update one record but would like to know if I can bulk update them. I constantly receive these requests to update the date. This time it is only 6 records but usually, I get the request to update even 50 records.

[This is the data that I received](https://i.stack.imgur.com/OBxj0.jpg)

[This is the data in the database table.](https://i.stack.imgur.com/Jxg4E.jpg)

I need to update the CASE\_DETAIL table by adding the judgment date into JUDGMENT\_DATE COLUMN which is currently null.

```
update case_detail cd set CD.JUDGMENT_DATE = '18/DEC/1998' where CD.OBJECT_ID = 5091449

```

Any advice in the direction of creating a SQL script that would bulk update the date column in multiple records would be of great assistance.

Answer: 
It's not a valid query string, but you could use `map` instead:

```
var joinArr = substr.map(n => "url" + n).join("=&") + "=";

```
Since question is tagged jQuery, you can use [`$.param()`](https://api.jquery.com/jQuery.param/) on a reduced object

```js
var substr = [1, 2, 3, 4, 5, 6];

var query = $.param(substr.reduce((a,c)=> (a['url' + c]='',a),{}))

console.log(query)
```

```html
<script src="https://cdnjs.cloudflare.com/ajax/libs/jquery/3.3.1/jquery.min.js"></script>
```