Between Condition is not working on server side $this->db->group_start(); $this->db->where('("'.$start_date.'" BETWEEN start_date AND end_date)', NULL, FALSE); $this->db->or_where('("'.$end_date.'" BETWEEN start_date AND end_date)', NULL, FALSE); $this->db->group_end(); This Between Condition is working on local but not on server side
I have two columns called price and date, so i want to sum the total of price where the month is 01: price | date ------------------- 200 | 01-01-2022 100 | 09-01-2022 400 | 01-03-2022 120 | 01-06-2022 Here my…
I need to make the connection with the PK from a table to its correspondent FK from another table. This is my db: I only have the case_id from the case table, and I need the case_uid from the case_test…
I'm trying to filter my table 'mange' with the condition of customers who eat both the "mexicaine" and the "végétarienne". I have a table 'mange' which contains 'nom' and 'pizza' I have tried to filter with select * from mange…
please assist with the following. i m trying to run a script that accepts one argument $1. The argument can either be a string or character or an integer. I want to use the argument in there where clause to…
I have a nodejs express web with a mongo db with const AuthorSchema = new Schema({ first_name: { type: String, required: true, maxLength: 100 }, family_name: { type: String, required: true, maxLength: 100 }, date_of_birth: { type: Date }, date_of_death:…
I`ve got code that shows all of the placements for a user. Is there a way to narrow this down to only show placements that are in the future? I've tried to do this using where and carbon::now to no…
SELECT '1000000' AS number UNION ALL SELECT '541' AS number UNION ALL SELECT '-500' AS number UNION ALL SELECT '100' AS number UNION ALL SELECT number, 'biggest' AS result WHERE number = 1000000 How to make this work? My task…
Imagine 2 table with the same structure but that might have some rows not equal for the same primary key. What really happen when using a where clause like this : " where table1.* <> table2.* " ? I "used"…
I need to make a query to return only active records which in this case are imo_status == 1 What is the best way to make this query? I'm using CI3 Below is the source code. // LISTA OS AGENCIAMENTOS…