I have a database with a list of soccer fixtures for the year. Fixtures are contested on most weekends - but, notably, not all. The website currently displays fixtures in this style/format, with separate MySQL statements running for each weekend:…
I have a user table as follow: CREATE TABLE `user` ( `Id` bigint NOT NULL AUTO_INCREMENT, `FirstName` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_520_ci NOT NULL -- more column ); Now when I run the following procedure: CREATE PROCEDURE myProc ()…
i try make code for search and this is my code: $services = Service::query()->with('plans')->latest(); if ($request->service_name) { $services = $services->whereRaw("CONVERT(JSON_EXTRACT(name, '$.ar') using 'utf8') LIKE '%$request->service_name%' ") ->orWhereRaw("CONVERT(JSON_EXTRACT(name, '$.en') using 'utf8') LIKE '%$request->service_name%' ") ->orWhereRaw("CONVERT(JSON_EXTRACT(name, '$.he') using 'utf8') LIKE '%$request->service_name%' ");…
I am new to programming and I need some help trying to understand how this works. So I got assigned to create a database or a storage that will have mostly PDF documents in it. We keep those documents on…
Can anyone please help me with an SQL query which will allow me to populate the real_name column in table 1 with values from both first_name and second_name columns in table 2 by referencing the usernames. TABLE 1 audit_username real_name…
I'm sorry if the title of the question is somewhat deceptive, I don't really know how to phrase this. I have a table like this: +---------+--------+--------+ | name | key | value | +---------+--------+--------| | Stephen | Age | 23…
How can i multiply value in SQL only for in my case specific device (IP)? My table: ID DEVICE POWER ENERGY DATE_OF_READING 1 192.168.25.35 165 250241 2023-09-15 08:25:04 2 192.168.25.36 320 190322 2023-09-15 08:25:04 What i want is that sql…
I have no idea why I am having such trouble with this but I can't get this to work properly. I am trying to create a stored procedure that updates a booking datetime for a bookingid of my choice. I…
I'm learning SQL, and I've just learned about inner joins. The thing is, I'd been taught some other way to join tables before, and I don't understand the difference For example, the way I already knew: SELECT E.SALARY FROM EMPLOYEES…
I am trying to obtain the following result: Imagine I have an object table in the following format Name Object id Status A A. . On A B. . Off A C. . Other B D. . On B E.…