I have two tables 'poolTemp' and 'weather'. Both tables contain the columns "timeStamp" and "tempC". I want to join the tables with both "tempC" but only when poolTime.timeStamp is within 5 minutes of weather.timeStamp poolTemp.timeStamp data is recorded up to…
I have this string "I need red budget car". I have a table where in column keywords I have comma-separated words. I know that I can use find_in_set to search if a specific word (ex.budget or car) exists in that…
I have a tickets table with this info: ticket_id | user_id | used_at ---------------------------------------- xxx | xxx | datetime xxx | xxx | datetime xxx | xxx | datetime I want to get a list of all users who has…
I am a beginner trying to build very simple inventory system using PHP + SQL I have 2 warehouse. I added 2 tables, 1 for each warehouse contains (item id)-(in)- (out) like shown below table1 item id in out item1…
SELECT DISTINCT info_person.userUsername, infoExamResult.resultPoint, infoExamResult.resultPercentage, infoExamResult.optAnswer FROM info_person INNER JOIN infoExamResult ON infoExamResult.personID = info_person.personID where infoExamResult.datetimeStart BETWEEN "2024-03-18" AND "2024-03-26" and infoExamResult.optAnswer = "COMMIT" ORDER BY info_person.userUsername Outcome which resultPoint are Score and resultPercentage are Percent of max score…
I am developing a react website and I am trying to customize select option based on my own Figma design. enter image description here This is my Figma design and I made it like this : const CustomDatePicker = ({…
I have a table sample below: Table_A col1 col2 881 113 988 899 113 765 765 765 122 881 300 400 765 910 910 345 999 988 What I want to achieve here, is to get the last chaining data…
So I have a MYSQL table, and one of the columns (call it TAGS) is an array which contains a list of tag names. For example, a given entry could have a TAGS column value of "TAG A, TAG B,…
new to php and MYSQL,and would like some help, so please be gentle I have some code which populates a HTML table using php echo. The statement is: $query= "SELECT Distinct AgeGrp, Gender,Dist, Stroke, First, Family, Name, Year, Time, Event,…
I would like to calculate the fraction of rows fulfilling some criteria. So something like this: (SELECT COUNT(*) FROM table WHERE col_name > crit) / (SELECT COUNT(*) FROM table) However, this creates a syntax error when I tried it. How…