I am basically trying to select data from the backend mysql database based on the input gathered in a previous drop down. However, I am not able to get this working. Looks like I am missing something, but unable to…
I'm not sure what is happening or why this is happening so hopefully someone can give me tips on how to debug or where to look. I have 2 docker containers, 1 for phpmyadmin and another for mysql. The phpmyadmin…
I want to duplicate a specific teacher so that they appear twice in the output of a SELECT statement. Teacher Grade District Mr. Smith 3rd West Mrs. John 4th South Mr. Cameron 2nd North Mr. Cameron 2nd North Kirk Horn…
I have two tables, one being the employees information and one with their task progress information. They look like this. employee table Task table empid first_name last_name task_id stats pf empid 1 lana law 1 0 1 6 5 Carla…
How to select name with the highest power and highest salary Id Name Salary 1 Kobe 50000 2 Lebron 500099 3 Steph 628228 4 Thompson 50505 5 Shabu 393828
I have a column in my table that contains 10-digit hts codes (0000.00.0000). Some of the values do not have the full stop points (0000000000). How can I add the full stop points to all the rows that do not…
I am new to SQL and having a hard time to filter out a table using SQL query. I have a table as below CATEGORY | NAME | UID | LOCATION ------------------------------------------------------------------------ Planning | Test007 | AVnNDZEGp5JaMD | USER Planning…
I want to create product filter for multiple categories. User will select for ex. Mobile phones category via form select element and then there will be showed options for this category which user can choose, for ex. Color, processor,... And…
I'm using regex word boundary b, and I'm trying to match a word in the following sentence but the result is not what I need. Connector Punctuations (such as underscore) are not being considered as a word boundary Sentence: ab﹎cd_de_gf|ij|kl|mn|op_…
I have json data in a column called settings: {"AreaAdmin":null, "StatsAreaAdmin":null, "Logo":"1664805113094.svg", "ExportFree":null, "Banner":null, "BannerMobile":null, "BannerRetina":null, "BannerAddr": null } I have figured out how to grab a json element: SELECT * FROM `user` WHERE JSON_EXTRACT(settings, "$.Logo") How do I grab…