Doing PHP word processing
I have retrieved data from a MSSQL server table. I was able to display them thanks to a query. I would like to be able to modify these data without touching the table For example the values which are in…
SQL query for 'The account number is masked by an asterisk(*) except for the last 4 digits in both previous and new value.' – Mysql
table ACC_NO pre_val New_val 123489432 123489432 123489435 123489532 123489532 123489435 I asked some of my friends but not getting how to write the sql query.
Building a SQL WHERE statement based on passed parameters through GET method – PHP
I'm building a search page in PHP, using multiple select options and, passing the values from one page to another via GET method. But I'm get stuck with the WHERE clause where unpassed values won't fill my query and ultimately…
How to get cumulative values and reset it under a condition, and then aggregate it again on Postgres – Postgresql
I am trying to get the column cumulative_point like below. date point reset_date cumulative_point 2019-01-01 00:00:00 1 true 1 2019-01-02 00:00:00 3 false 4 2019-01-03 00:00:00 1 false 5 2019-01-04 00:00:00 2 false 7 2019-01-05 00:00:00 1 true 1 2019-01-06…
Would indexing a text field allow for better performance during a regex search? – Mysql
So I have a blog posts table with a title field and I would like for users to be able to query posts via this field. For this, constructed a query where the string the user types into the search…
SQL query with AND? – Postgresql
I have a little problem writing a request. With the data example below, i want to recover the archive_id that have a document_type_id = 18 and 20 +------------+------------------+ | archive_id | document_type_id | +------------+------------------+ | 1 | 20 | |…
How to remove duplicate entries from json string in SQL Server
I've checked stackoverflow as well as google but could not find any solution. What would be the proper way to remove duplicate entries from an nvarchar field that contains json string in SQL Server? For my case, let say I…
How to get the full calendar months between two dates in PostgreSQL
I have two dates, e.g. '2022-01-03' and '2022-03-04', is there any neat way to calculate ONLY the completed full calendar months between these dates? Some examples with their requested outputs: '2022-01-03' and '2022-03-04' full calendar months = 1 since only…
Best Practice Interpreting SQL Data with Switch/Case To Avoid Unnecessary Eloquent Calls – Laravel
I'm still new to Inertia/VUE3 & Laravel. I'm more familiar with PHP but I want to use best practices for what I'm doing here. I'm sure it's relatively simple so I appreciate all your help. I just wasn't sure what…
Gaps and island combined with a recursion – Postgresql
I have a gaps and islands SQL problem combined with a recursion. Background: I run a PostgreSQL database with school vacations and bank holidays from which I render calendar views for schools, city and what not. I code a lot…