How to update json data in postgresql database using laravel?

Question

how to change next data in database:

jsonData = [{"given_date": "2 1.05. 2002 year"}]

to

jsonData = [{"given_date": "21.05.2002"}]

try to replace date value with regex preg_replace('/\s|[a-zA-Z]/', '', '2 1.05. 2002 year'); — Ata
– Ata, Commented Dec 14, 2019 at 11:47

TsaiKoga · Accepted Answer · 2019-12-14 16:34:40Z

1

Postgresql update with regex:

UPDATE table
SET given_date = regexp_replace(given_date, '(\s|[a-zA-Z])', '','');

regexp_replace takes the value in given_date and be replaced by third parameter (empty string), according to the second regular parameter (match the spaces and alphabets). The fourth parameter is option like 'g(global)', 'i(ignore case)';

Postgresql regexp_replace reference

Laravel update with regex:

\DB::table('tablename')
->where(...)
->update([
'given_date' => \DB::raw("regexp_replace(given_date, '(\s|[a-zA-Z])', '','')")
]);

edited Dec 14, 2019 at 16:34

answered Dec 14, 2019 at 16:14

TsaiKoga

13.4k2 gold badges23 silver badges31 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to update json data in postgresql database using laravel?

1 Answer 1

Postgresql update with regex:

Laravel update with regex:

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Postgresql update with regex:

Laravel update with regex:

Comments

Your Answer

Sign up or log in

Post as a guest

Related