“Query all rows in MySQL with a certain text in a column?
I am trying to query a table to get all the rows, but also return which ones match a string search. For example, here is what the table would look like. id title 1 foo 2 bar 3 foobar 4…
Can WHERE be used on JSON in MySQL?
I am trying to apply the where clause on json data instead of table and column. I have tried lots of way but didn't get the result as I want. Below is a query: select CustomerName as 'CustomerName', TRUNCATE(JSON_VALUE(BillData, '$[0].due'),…
Why aren’t images downloading when I get the link in MySQL?
I am fairly new at this, I was trying to display and download images stored in database as a image path. the display works fine but when I try to download the images from the download button the URL shows…
Can I get the result of an exists query in Typescript using MySQL?
I'm trying to get the result of an exists query using typescript but I can't get the '1' or '0' of the object that the query is returning. code.ts const rslt1 = query(`SELECT EXISTS(SELECT * FROM patients WHERE cc=?)`, [params.ccInput]);…
Can two SELECT query results be combined in MySQL?
Background: I have a number of sources that reference a relationship. I have calculated the percentage of the sources in which any particular relationship is found (since multiple sources sometimes reference the same relationship). Any relationship that is found in…
How can Twitter-api generate unique, incremental IDs within an entity?
We're building a ticketing system for our customers (enterprise clients) and we're trying to come up with a way to have a sequential, unique ticket ID generation system that is also user-friendly. Unique ID generation is a fairly well-known problem…
How do I pass a value in a common param in a MySQL statement?
I have an sql query on which I want to pass a param value and get the result but I am not able to achieve this. SELECT CASE WHEN x>0 and x<=5 THEN 1 WHEN x>5 and x<=10 THEN 2…
Can MySQL delete a key-value pair in a JSON column?
I am trying to update a column in MySQL, where it contains a json encoded value with multiple key-value pairs, but cannot write the exact query. Can anyone help? For example: tableA: id response 1 {"event_id":"11111","contact":{"contact_id":"as2344","answers": [{"answer_id":"2223e"}],"tags":"cadd76","question_id":"67888"} From the above…
Can’t load JDBC driver ‘com.mysql.cj.jdbc.Driver.class’?
I'm trying to connect Context.xml file to my Demo.java(Servlet) on Eclipse. Cannot load JDBC driver class 'com.mysql.cj.jdbc.Driver.class'. Please let me know where I'm wrong. Please help. Demo.java(servlet) with console Context.xml file mysql-connector jar is added wherever possible. still not able…
Does GROUP BY in MySQL count grouped rows?
I am doing a beginner level course on Khan Academy for SQL. CREATE TABLE exercise_logs (id INTEGER PRIMARY KEY AUTOINCREMENT, type TEXT, minutes INTEGER, calories INTEGER, heart_rate INTEGER); .....Inserted data into the table.... SELECT type, SUM(calories) AS total_calories FROM exercise_logs…