In a ColdFusion application I have a query with several joins and I need one MAX number from one of the tables. I am getting all tangled up in 'only_full_group_by'. I cannot disable it in etc or in the Administrator,…
My PHP application is being attacked by adding a UNION statement to input of username. Specifically, where I check for input of a valid username the sql is modified to be select username from user where username = '-8546' UNION…
I have some tables that contains the payment details of students. In one of the tables, a column collects data in json string. I want to extract the value of amount from the string below. However, you would notice that…
I have the following MySQL tables: CREATE TABLE `person` ( `id` int NOT NULL AUTO_INCREMENT, `reference` varchar(100) NOT NULL, `email` varchar(255) NOT NULL, PRIMARY KEY (`id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb3; INSERT INTO `person` (`id`, `reference`, `email`) VALUES (1, 'PK001', '[email protected]');…
I have a few records in elastic search I want to group the record by user_id and fetch the latest record which is event_type is 1 If the latest record event_type value is not 1 then we should not fetch…
I need to create a table where each user (approx 60 atm) would have a defined task for each day. Right now the database have one column for each user with the task name in it (which is bad in…
AND t1.Team IN (SELECT Team FROM t2 WHERE t3.ID = t2.ID) How can I make above AND as optional, if the sub-query does not have any results, do not even consider AND t1.Team IN (""). Something like this does not…
I have a multi-join query that targeting the hospital's chart database. this takes 5~10 seconds or more. This is the visual expain using mysql workbench. The query is below. select sc.CLIENT_ID as 'guardianId', sp.PET_ID as 'patientId', sp.NAME as 'petName' ,…
In the following data: id_1 id_2 colA colB colC 1 2 2022-01-02 scroll fast 12 1 2 2022-01-02 scroll fast 12 1 3 2022-01-03 scroll fast fast 11 1 3 2022-01-03 scroll fast fast 11 1 3 2022-01-03 scroll fast…
I need a query where if a column from a row was filled, return her, else return another column value in the same table. This code will insert like a subquery, so, I need that return just only value. **…