I have a table name deny_keywords in database with this structure: id word 1 thief 2 crook 3 killer and I have an input that user can send a text and this text Placed in variable name $user_text. Now I…
I have a VARCHAR data type in a order_date column which contains dates, I would like to convert it to DATE format except for null values. How can I solve this?
Given the following two relational schemas, the EMPLOYEE relational schema records the employee number (ssn), age (age) and the department (dno), the primary key is ssn, and the DEPARTMENT relational schema records the department number (dnum ) and name (dname),…
Simplified the following question I got from a coding challenge... I have a table grades like: year sex person mark 2000 M Mark 70 2010 F Alyssa 23 2020 M Robert 54 I want to select the people per year…
For example 'ABC-12345-6789-10' I want to return "10" as these are all the characters after the last "-" dash. I have tried this but I only get a zero at the end: SUBSTRING('ABC-12345-6789-10',len('ABC-12345-6789-10'),LEN(CHARINDEX('-', 'ABC-12345-6789-10')))
I have a query that is taking transactions (buying and selling of items) to calculate the gain/loss when the running total resets back to 0. The fiddle is here: https://www.db-fiddle.com/f/974UVvE6id2rEiBPR78CKx/0 The units of each item can be added and subtracted…
I want to update data using query but when column is not null, it will not update and still use old data. I tried with this query but failed. UPDATE tableA SET column2 = case column2 WHEN NULL THEN to_timestamp('2022-08-09…
Question: SQL query to best get the desired result below. Input: Identifier Date 1234 2022-01-01 1234 2022-08-11 7890 2022-08-11 4444 2022-08-13 Output: Identifier Date 7890 2022-08-11 4444 2022-08-13 Note: Want only new entries that was not in the past. Tried…
SELECT #Opportunity Details o.Id AS 'Opportunity ID', o.Name As 'Opportunity', o.Project_Assigned__c AS 'PM Assign Date', CASE WHEN o.StageName IN ('Best Case','Commit','Committed','Discover and Assess','Pipeline','Probable','Sales Qualification','Upside') THEN 'Pre-Sales' WHEN o.StageName IN ('Omit - Closed','Omit from Forecast','Omit-Closed','Omitted') THEN 'Omit' WHEN o.StageName IN ('Rejected','Lost','Cancelled')…
In MySql, is there any way of getting a partial match if you use something like: SELECT * FROM table WHERE name LIKE '%orange llp%'; And the output to be something like: +-----------------+ | name | +-----------------+ | Orange |…