$dataQuery = $dataQuery->where(function ($query) use ($fullname) { $nameParts = explode(' ', $fullname); if (count($nameParts) === 2) { $query->where(function ($q) use ($nameParts) { $q->where('users.firstname', 'like', '%' . $nameParts[0] . '%') ->where('users.lastname', 'like', '%' . $nameParts[1] . '%'); }); } else {…
I'm struggling to find the best way to get the total order value (sub-total - deduction) for a specific date or date range (for example today). I don't want shipping value included. The complexity is because the sub-total and deductions…
I have a postgreSQL table that contains the following: select * from ci_grp; ci | grp ------------+------------------------------------------------------------------------------------------- Ci1 | [{"Name":"TEAM.Virtu"},{"Name":"TECH.LinuxDevice"}] Ci2 | [{"Name":"TECH.LinuxDevice"},{"Name":"TEAM.Monitoring"}] Ci3 | [{"Name":"TEAM.Noc"},{"Name":"TEAM.Virtu"},{"Name":"TECH.DellEsx"},{"Name":"TECH.SNMP"}] Ci4 | [{"Name":"TEAM.Monitoring"},{"Name":"TECH.Postgresql"}] Ci5 | [{"Name":"TEAM.Monitoring"},{"Name":"TECH.LinuxDevice"},{"Name":"TECH.ZabbixProxy"}] I need to get a reply that would…
I'm working on an express.js project, using Sequelize as the orm, and postgres as the engine. I'm working on improving the performance of a slow select query that does many things, and one of them is comparing the acronym of…
I have a query where I need to add a positional argument into a call to max(expression). SELECT max(my_real_column) FROM my_table I've tried the concatenation operator, e.g. my_real_column || $1, but that yields an operator error: SELECT max(my_real_column || $1)…
Let's say I have two tables (from uploaded csv files) and I want to do a diff based on an id+territory in the new file that wasn't in the old file. The easiest way to do this is something like:…
I have a database with the following structure table_a | id | username | | -------- | -------- | | 1 | 'a.a' | | 2 | 'a.a' | table_b | id | table_a_id | | -------- | ---------- |…
So, I have the following table where Col1 can have 2 values: A or B Col2 can have 2 values: P or Q Col3 can have 3 values: L, M or N Roll_number is just a numeric Id number Roll_number…
I have some rules which gets fired if a criteria for a process gets fulfilled. I am calculating the performance of those rules in a confusion matrix form. If the rule was fired, it means the process was predicted positive.…
I'm a begginner learning to make "contact us" page (in a bit of an improvised way, as you'll see hehe). I defined some variables using global variables. But when write the query to save them to the database, MySQL understands…