MySQL fulltext search doesn't match the word 'christoffer82' and its ilk with the root word 'christo' and I have no idea why. This login only appears once in the table (it doesn't appear in more than 50% of the results)…
I am having 3 tables - student, department and exam_results. What I am trying to do here is to select all of the department/s name/s which have the highest grade for example 6. I have tried the following query but…
I am trying to count matching values from customer column on table 'Customers' and update their values on the Count Column in table 'Summary'. I also want to Check if the Date is <= Todays Date. Table "Customers": ID Customer…
I have a MySQL database with lots of entrys with columns like "local_time", "temp", "wind", etc. What I want to archive is get in just one query the MIN value for temp, the MAX value for temp in each day…
There's a simple table with columns a,b,c,d. I want value in d to be a+b if c>0 and a-b if c<=0. How can I do this? I tried this code and it doesn't work. How can I dynamically insert data…
I'm thinking my way to do that is a little archaic, not optimized... i don't need super detailed statistics, lets say i want the number of clicks on a link on a blog post per (actual) day/week/month/year nothing more, don't…
I have the following table: create table foo (id serial primary key, ts date, value int); Populated with 10k records already. Now I'm trying to find a way to efficiently update multiple rows in one go, so I wrote this…
I want to select rows from tags table where tag name includes SOMETHING. The results must be sorted in a smart way: records which start with SOMETHING should go first, and then should go the rest. It can be easily…
Sample contents are: id created_dt data 1 2023-01-14 11:52:41 {"customers": 1, "payments: 2} 2 2023-01-15 11:53:43 {"customers": 1, "payments: 2} 3 2023-01-18 11:51:45 {"customers": 1, "payments: 2} 4 2023-01-15 11:50:48 {"customers": 1, "payments: 2} ID 4 or 2 should be…
name -- country -- order john Abraham -- USA -- burgar john Abraham -- USA -- cake john Abraham -- USA -- sugar CR RONALDO -- PORT -- burgar MESSI GAR -- ARG -- burgar john Abraham -- FRA --…