I have a table in MySQL 8. In a varchar column, I want to replace long substrings by another substrings. I can find those rows using this regex: SELECT notetext FROM mytable WHERE notetext REGEXP '[a-zA-Z0-9_.:/-]{25,}'; This Regex searches for…
I have 3 tables I am trying to query, with one table that links the other two. The tables are CITY, SITE, and ACTIVITIES. They contain sites within cities, and then separate activities at each site. Not every site has…
I am working with a hierarchy problem where the nodes have two parents and need get only the nodes where both parents are in the result. In the happy world, this query would be perfect WITH RECURSIVE granters (id, parents)…
I have table, Table Book id,name,buyers And each row has the list of buyers. buyers are about 100000. So now I have two ideas. First one is Push the array of 100000 elements in row id, name, buyers 1, nice…
The goal is to find passengers in a flight database who accumulated 20,000 or more miles. I am asked to find the 10th passenger with the highest total miles. First I needed to create the top 10 list using the…
How do I display the 'like komodo' and 'average(amount)' commands at the same time can you fix my code guys here is my code select * FROM komodoshop where name like '%komodo' and AVG(amount) from name; i want to use…
I am a simple beginner that want to learn programming and I am a little confused I have three entities: administrator (the only seller), customer and products. Beetween these entities has to be the next relation? Administrator and Product (@OneToMany),…
When i use docker compose up for building all service and run when building stage backend(spring-boot) cannot connect MySQL database it cannot build and run image for backend. I try to set all service is in same network but it…
We have a Spring boot Web application where spring boot version is 1.5.6. After upgrading the AWS MySQL RDS to 8.0.28 from 5.7.0 we are getting liquibase error. I have upgraded the MySQL connector dependency to version 8.0.34 and liquibase-core…
I have a table named "Applications" where I keep track of the applications made by my candidates to vacancies. Now, I need to write a statistical query for HRs, and when an HR logs in, I should bring the candidates…