How do i go on about on a query for where i wanna extract the same first name but the last name is different? NAME ------ Chris Stutter Chris Lamb Alfred Dark Kristine Light output: Chris Stutter Chris Lamb
Good morning! I'm a bit stuck with this question. I know it's not complicated (Because I'm pretty sure I'm close to the answer) But I've been Stuck for a bit now. I'm totally new to MySQL My database code :…
I have multiple products on my website that have hardcoded links to other products in the product description (text). Those links are mixed case and are causing issues with duplicate pages on the Google index. I would like to convert…
This query return users from database MariaDB (MySql). I need to remove rows from result, where in surname is added "(old)" OR "- R". How to edit a query? SELECT au.id, au.name, au.surname FROM statements s JOIN aduser au ON…
There was a moment where I need to calculate the data, but there are empty fields (null) and I wanted him to skip if there is nothing in some fields. Tell me how to prescribe it, otherwise I get an…
So my table looks like this PK1 | PK2 | User(not unique)| value 1 | value 2| timestamp when added I want to get most recent values for value 1 and value 2 for every user. How would I achieve…
I'm working on a rights verification system. In order to verify that the user has access to the documents, I make a request to the database There are 2 cases when you can get access: The user is in the…
I have a table that collects securities holdings data for Funds like below. How do I extract latest data for each FundName? EffectiveDate FundName SecurityName PercentageOfAssets 30/06/2022 Fund A xxx 33.33% 30/06/2022 Fund A yyy 33.33% 30/06/2022 Fund A zzz…
I have php function with query I want to add different Order by ASC/DESC depending on the form value the user selects so I had if statement inside the query line. I tried but I get no error and no…
I would like to to shuffle some columns from a table in Postgres database. I have 2 millions rows. I need to update all not null values by another. I need to keep the same dataset. It's not possible to…