I am using a function REGEXP_REPLACE within SQL to generate a slug value from name column UPDATE tag SET slug = LOWER(REGEXP_REPLACE( REGEXP_REPLACE('Team Building 2022', '^[^A-Za-z]+|[^A-Za-z]+$', '', 'g'), '[^A-Za-z]+|(?<=[a-z])(?=[A-Z])', '-', 'g') ); But I get: team-building Result I want is:…
I'm making a competitive two player game and after each game I store a record of that game that includes the score, player names and the date. I would like that if one of the users deletes their account the…
I have a complex SELECT query with joins, but to simplify it looks like this: SELECT name, surname FROM table1; The resulting output is: name surname john smith jacob smath judy smooth I also have another complex query, let's say…
i have one table TABLE 1 ID CLASS GENDER SUBJECT A1 6A A1 ENG A1 6A A1 MATH A1 4A A1 COMPUTER A1 3A A1 GK I want to copy and paste the records in the same table(table1) with ID…
I have a table comprising a list of artists added to a playlist during specific years (2018 - 2022). I want to pivot the data into five "year" columns with corresponding artist names added in those years. I used the…
I have a table named assets. Here is the ddl: create table assets ( id bigint primary key, name varchar(255) not null, value double precision not null, business_time timestamp with time zone, insert_time timestamp with time zone default now() not…
Below is the query which finds the matching record and returns those "main"."item"."id" which matches the values inside IN clause. select main.item_vendor.item_id from main.item_vendor join main.item on item.id = main.item_vendor.item_id WHERE "main"."item"."id" IN ('188646', '200000699') Above query returns only one…
I have the following history table (record user action): ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | parent_id | property_names | changed_property | time_c | outcome | ------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- | 123456 | {PhaseId,LastUpdateTime} | {"PhaseId":{"newValue":"Fulfill","oldValue":"Approve"},"LastUpdateTime":{"newValue":1671027321749,"oldValue":1671027321170}} | 1671027321749 | success | | 123456 | {PhaseId,LastUpdateTime,ApprovalStatus} | {"PhaseId":{"newValue":"Approve","oldValue":"Log"},"LastUpdateTime":{"newValue":1671011168777,"oldValue":1671011168043},"ApprovalStatus":{"newValue":"InProgress"}} |…
I want to present information from a MySQL DB (MariaDB, actually) approximately as follows: SELECT Client, Year, SUM(Sales) FROM MySalesTable GROUP BY Client, Year ORDER BY Client, Year DESC The issue is, if there is no data for a particular…
Postgres implicitly sorts row based on the group by column. In MySQL, we can change this behavior by setting the ORDER BY NULL. Is there any similar alternative way to achieve this in Postgres [Reference]?