This is what I tried: $time = date('Y/m/d'); $alerts = $repository->findBy(['datum' => $time]); and $time = date('Y/m/d'); $lessons = $repository->createQueryBuilder('q') ->where('q.datum LIKE currentDate') ->setParameter('currentDate', $time); For some reason those don't work and I have no idea why. It should be…
How can I dynamically build mysql where clause based on number of words in an array to have all words match at least 1 of the 2 fields? I need all the words to be used; meaning that each word…
I have a hasOne relationship. The image shows the records of the relationship which have the same "contract_id" Following result is required: I want to only select the last record with the highest "version" => 5, but only if the…
I have following table: CREATE TABLE `filldubl` ( `recid` int(11) NOT NULL AUTO_INCREMENT, `mykey` varchar(200) DEFAULT NULL, `id` varchar(10) DEFAULT NULL, `rn` int(11) DEFAULT 0, PRIMARY KEY (`recid`) ) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8; INSERT INTO `filldubl` VALUES ('1', '10.1109/ICLP56858.2022.9942468', '4762',…
Having problem with complex order. Here is structure and data: CREATE TABLE `mail_test` ( `id` int(10) UNSIGNED NOT NULL, `account_id` int(10) UNSIGNED NOT NULL, `score` float UNSIGNED NOT NULL, `from` varchar(255) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `mail_test`…
I'm storing JSON data in JSON type column in MySQL database. Tried to filter extra_data column for where payment_address is not null. Unfortunately couldn't find the right way. These are the queries I tried: SELECT * FROM orders WHERE extra_data->"$.payment_address"…
I have this input table: With which MySQL statement can I create such an output table?
I have a select query select id from tags Which returns data like id -- 1 2 I want to get data with a sequence number as shown below id seq -- --- 1 1 1 2 1 3 1…
So i have a table that's for products and depending on the product the col can have different values, example: Product DVD: SKU Name Price Size(MB) Product Book: Sku Name Price Weight Deppending on the product that is "DVD, book…
I am trying to filter data with search terms. But its not populate data. Any one can help me with this? Here is my code: $query = Lesson::select('lesson.*') ->join('lesson_language', 'lesson_language.lesson_id', 'lesson.id') ->leftJoin('content', 'content.lesson_id', 'lesson.id') ->leftJoin('lesson_role', 'lesson_role.lesson_id', 'lesson.id') ->leftJoin('lesson_brand', 'lesson_brand.lesson_id', 'lesson.id')…