when I execute this code it always returns the same message even if i send different email let message = ""; const findQuery = "select email from Users where email = ?"; const queryResult = await db.query(findQuery, [req.body.email]); if(queryResult[0] ===…
I have a table with dates and some other information, where the dates are not continuous (no weekends). How do I get all records from the last two days/dates (which I don't necessarily know beforehand)? While SELECT datum FROM trackproc…
example image data : when the js responds, the data has already been ordered by example image response js : example controller and query : $query = Verifikasi_tte::join('surat_ttes', 'surat_ttes.id', '=', 'verifikasi_ttes.surat_tte_id') ->join('users', 'users.id', '=', 'surat_ttes.user_id') ->join('jenis_surat_ttes', 'jenis_surat_ttes.id', '=', 'surat_ttes.jenis_surat_tte_id') ->select('surat_ttes.id','surat_ttes.klasifikasi','surat_ttes.no_surat','surat_ttes.tgl_surat','surat_ttes.created_at',…
I'm trying to make a very simple query to a MySQL 5.7 database but the query is slow and the explain shows it is not using the index, although it lists it as a possible key. Below is the query,…
I am trying to connect the container of my springboot application with the container of a mysql image using docker-compose, however when I run docker-compose up my terminal starts a loop where it starts the spring application, try to connect…
Good afternoon, I'm trying to execute this query with Laravel: SELECT COUNT(id) as total, (SUM(score) / COUNT(id)) as average, (SELECT COUNT(id) FROM rates Where book_id = :book_id AND score >= 1 AND score < 2) as count_1, (SELECT COUNT(id) FROM…
I have a database with multiple tables, and I want to add a column to one table that will be populated with different strings based on the contents of another table. Below are the tables of interest. CREATE TABLE Locations(…
I have this db table: http://sqlfiddle.com/#!9/e1dd38e/7 I am trying to query it so it goes thru each category, returning each subcategory's top 3 vendor's, ordered by their total of spend (sum(amount)), the vendors outside of the top 3 will be…
Hi everyone in the database a column called attachments stores data like this "a:3:{s:6:"saveTo";s:7:"wpmedia";s:14:"attachmentType";s:6:"images";s:11:"attachments";a:1:{i:0;a:6:{s:12:"attachmentId";i:176165;s:4:"file";s:68:"https://www.yallamission.com/wp-content/uploads/2022/10/MG_00283.jpg";s:8:"fileName";s:12:"MG_00283.jpg";s:9:"thumbnail";s:76:"https://www.yallamission.com/wp-content/uploads/2022/10/MG_00283-150x150.jpg";s:8:"fileSize";s:9:"292.85 KB";s:8:"fileType";s:10:"image/jpeg";}}} i need to fetch the image url only yet i am unable to do it successfully as i don't understand this format I tried to…
I have a table named Users, with userId as one of the column, the user can be in any one of given 5 possible states which are (Unregistered, registered, subscribed, premier, unsubscribed). I want a query which can give me…