I'm looking to get a list of all messages between users but only the latest message sent by either user A or user B in the database these fields are fromUser and toUser I need a list of the latest…
I have such table (simplified) id pos neu neg x 1 2 3 y 4 2 1 z 1 5 2 I use PostgreSQL and my goal is to get greatest value for each row, so i use next query:…
I'm trying to create a migration that changes the records I need in a table $sql = ''; $sql .= "UPDATE card_series SET Code = 903 WHERE ID = 1600;"; $cardsSeries1600 = CardList::find() ->where(['seriesId' => 1600]) ->orderBy('ID') ->all(); $cardNum =…
There are 3 tables, A, B, C. Table A has an id column, and B & C integer column which represents money and a_id which reference id in table A. Below is an example of table A, B, C table…
my_tickets +-----------+---------+ | ticket_id | user_id | +-----------+---------+ | 186 | 2 | | 187 | 2 | | 188 | 2 | | 253 | 33 | | 254 | 33 | | 256 | 33 | | 261…
Im running this query: SELECT id FROM posts WHERE title LIKE '%CERTIFIED INSTALLER%'; The text in the database is stored as 'ᴄᴇʀᴛɪꜰɪᴇᴅ ɪɴꜱᴛᴀʟʟᴇʀꜱ' which is of a unique font. The above query returns 0 results, but whenever I change 'ᴄᴇʀᴛɪꜰɪᴇᴅ…
Folks! I need some ideas, with the follow problem: I have a table in MySQL v5 that stores a string in a field, like the following: {"content":{"serviceResponse":{"state":{"code":"04","gloss":"CONTINUE"},"products":[{"product":{"productCode":"1" ,"subProductCode":"1"},"productAmount":{"amountGranted":1100000},"groupRisk":{"riskGroup":"A2"},"additionalinformation":{"franchiseTC":"3"," percentAdvance":"70.0"}},{"product":{"productCode":"2"},"groupRisk":{}},{"product":{"productCode":"7"}}]," client":{"newClient":"false","riskGroup":{"riskGroupCode":"A2"}}}} I need a MySQL v5 (version is important) SQL query…
I need some help. I have a table in PostgreSQL with logs of user sessions. The table has 3 fields: id, action, and action_date in the timestamp format. The action field has 2 possible values: "page_load" or "page_exit". The action_date…
I have a problem statement: Write a Stored Procedure that populates a table with certain date attributes. The data would be populated for 1 year. For example the date 14-07-2020 is passed as an input parameter, then the stored procedure…
I'm getting an error while attempting to populate my table with the following query: INSERT INTO d_table SELECT category.name, film_category.film_id FROM category INNER JOIN film_category.film_id ON film_category.category_id = category.category_id It returns an error "relation film_category.film_id does not exist" These are…