Here is an image of my current code This is what my current code outputs when I enter it This is what I need my code to be outputting
My current code is to try to find 2 words "Red Table" in Title: SELECT `id`,`title`,`colors`, `child_value`, `vendor`,`price`, `image1`,`shipping` FROM `databasename`.`the_table` WHERE `display` = '1' and (`title` REGEXP '([[:blank:][:punct:]]|^)RED([[:blank:][:punct:]]|$)') and (`title` REGEXP '([[:blank:][:punct:]]|^)TABLE([[:blank:][:punct:]]|$)') The problem is, this is so slow!…
I'm trying to delete duplicate rows in a table. The email field needs to be be unique in the table for the code after it to run. Here's my code: DELETE FROM deleteRequests WHERE Email NOT IN ( SELECT MAX(Email)…
In a Postgres DB, given the following simplified dataset of orders: ID STORE_ID UPDATED_AT 1 "store-1" 2021-01-01 2 "store-2" 2021-01-02 3 "store-3" 2021-01-03 4 "store-1" 2021-01-04 5 "store-2" 2021-01-05 6 "store-3" 2021-01-06 ... 1000 "store-1" 2021-02-05 How can I write…
A have a ton of variable products. I'm using cron to run the script every X minutes for fetching stock level from an external source. If I use wc_get_product_id_by_sku and update_post_meta it takes too long so I'm trying to find…
Background I'm running Postgres 11 on CentOS 7. I recently learned the basics of recursive CTEs in Postgres thanks to S-Man's answer to my recent question. The problem While working on a closely related issue (counting parts sold within bundles…
I have been able to select this data, using these two sql queries Query 1: SELECT article_id, amount_required, amount_sold FROM products_articles,sales WHERE sales.product_id = products_articles.product_id Query 2: SELECT * FROM articles What I want to do, is go through the…
Good evening, I am currently working on the implementation of a shopping cart through PHP and MySQL, I am getting the following error at line 172 onwards, I have been looking at the quotes but I cannot find the problem,…
I see this error in phpmyadmin: The number of joins that do not use indexes but I never use join in my code. Now I want get a list of query that do not use indexes. How can I get…
My goal To calculate the sum of components sold as part of their parent assemblies. I'm sure this must be a common use case, but I haven't yet found documentation that leads to the result I'm looking for. Background I'm…