Mysql – Update SQL Cells
I am searching for an easy solution. I wanna Update 800 rows of data. There is no unique ID so the ON DUPLICATE KEY Update is not possible. I only show 3 rows of data, but there are over 800.…
Mysql – SQL WHERE clause matching on the same field twice (or more). What is the right JOIN statement to be used?
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…
Postgresql – Why the result is different for SQL string equality and for LIKE operator in Postresql?
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…
MySQL: Have unique values in a column with one exception
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 – Data without duplicates is retrieved by a Laraval query
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…
Use a column of arrays as a condition in Postgresql
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…
Mysql – SQL SELECT and WHERE
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')…
Laravel is there a way to optimize search across multiple fields?
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…
Mysql – SQL join and where with ON (specific items) to get results in order
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
Laravel where condition from string
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…