I had a completely working version on my Windows XAMPP testbed (in PHP) SELECT... ...WHERE itemTitle RLIKE '(?=.*A)+(?=.*B)+(?=.*C)+^((?!D|E|F).)*$' that stopped working when I moved the site to a real server with the error "repetition operator operand invalid". Research says that…
I'm using MySQL (8.0.33-winx64, for Windows) with Python 3 and mysql.connector package. Initially my mysql-8.0.33-winx64data folder was rather small: < 100 MB. Then after a few tests of CREATE TABLE..., INSERT... and DROP TABLE..., I notice that even after I…
I have a form that takes a CSV file and uploads it into a MySQL table. Each of the entries upon the upload features characters that I need to remove, as well as the head row. For example: `| ="username"…
I have 2 tables... crew_availability (ca) which has id(INT), admin_id(INT) and usable_date(DATE) fields. reservations (r) which has id(INT), ride_id(INT), admin_id(INT) and ride_date(DATE) fields. The following EXCEPT query provides expected result in that it gives remaining crew availability. SELECT ca.admin_id, ca.usable_date…
We have a Linux (Ubuntu) based server and host some smaller websites based on wordpress. Since a few days we got the error message that there is an error with the database connection. This error occures on all the websites…
We have a couple of staging tables for Data in mysql db that we read from a input file. In the first table, the data is dumped as is. This data is then processed and grouped in certain ways and…
Let's assume the table has 110 rows. The following skips the first 10 rows and returns the other 100: SELECT ... FROM ... ORDER BY ... LIMIT 10, 100 Is there a way to replace 100 by whatever is left?…
I wonder if this query is possible using json query. I need to select all records that have more than 3 values a like. for example, I have an array [1,2,3,4,5,6]. Database record has: # ["1","2","3","9","4","2"] selected <--- this contains…
I've been trying pretty much every possibility that came into my mind, but no luck. I'm trying to show a list of companies created WHERE the parent user_id in the Companies table is backpack_user()->id OR company_id AND user_id are present…
I have a master item ship/return table where we keep track of every SN shipped (date it was shipped, where it was shipped to, and if the SN was returned). We have some records that show a SN was shipped,…