I have a DB with two tables: employees table: fields = {ID, name} turnShift table: fields = {ID, date, ID_employee1, ID_employee2} Here is an example of this DB. Using MYSQL, I'd like to execute a SELECT query able to show…
I have a table with login names. Login names does not contain any special character just [a-zA-Z0-9] and of type varchar(50). I would like to find a user by login name eg.: CREATE TABLE users( login character varying(50) ); INSERT…
I've created a column of usernames but the ids for each row is linked to another table. If a user is deleted, I'd like to change the username to 'Deleted'. So I'd like to allow for unique values except for…
laravel query with fetch data I have below table in "ORDCOMPLETE" is duplicate with same order ID #11310, so I need to remove this duplicate id with the same prefix. #11309 ORDCOMPLETE7104671693208650 $30 #11310 ORDCOMPLETE4335631693207733 $30 #11310 ORDCOMPLETE4335631693207744 $30 #11310…
I want to use a column of arrays as a condition in postgres. The condition is applied on a column composed of text value. This is the column made out of arrays (after be transformed with string_to_array. And this is…
I Want to select transactions under PL Category 52105 and transaction codes 9007 & 9803, but the results are are picking other transaction codes other than those 2. Where am I getting it wrong? FROM [Steward].[dbo].[vwNONFUNDED_RECOMP_04] WHERE PL_CATEGORY_CATEG_STMT IN ('52105')…
I have a search on the title, description and author fields, is there a way to make it faster or shorten the code? public function index(Request $request) { $queryStr = $request->query('search'); $games = Game::withTrashed() ->with('user') ->where('title', 'like', '%' . $queryStr…
sample code SELECT b.title, i.barcode FROM biblio b JOIN items i ON b.biblionumber= i.biblionumber Join biblioitems bi ON i.biblionumber=bi.biblionumber where i.barcode IN (4088,6183,6191) above SQL given results as below, how do I get results in IN (4088,6183,6191) as entered order
I just want to make a where clause from string as my where clause depends upon the other variable. I did like this $where_condition = "post_flight_informations.schedule_year,=,2022"; and then applied to query like this ->where($where_condition) but it is taking $where_condition as…
In a trading platform, users have three different actions: LOGIN, SEARCH, ORDER. Abandoned SEARCH action is defined as: customers LOGIN then do some SEARCH and do not ORDER before next LOGIN. Now I have a table: action_table, recording customer_id, action,…