I've got an older table where some IDs are stored in a varchar as comma separated list. name street some_ids Pete Teststr 3,4,7,2 Tom Teststr 1,4,7,3 Inga Teststr 3,7,2,5 I.e. need to find the entries containing 2 in column "some_ids"…
I am designing the database for a project that I am working on, basically the project is a question bank. Each question has a flag(mark), where the user can set it as true so that they mark it to get…
I am trying to make a full-stack CRUD web app using mysql through phpmyadmin, which will be sent to an express front end (this is my first time ever working with SQL and PHP so pardon my mistakes or my…
I'm very new to creating my own projects and SQL in general and I'm having issues with having a "rank" column that will generate the ranking of a specific row of data based on the "time" column. I'm making a…
Having customer2 table enter image description here trying to execute below command select AccountNO,id_Proof, CASE id_Proof when id_Proof in('Passport','PAN') then 'P' else id_Proof end as abc from customer2; It working opposite enter image description here please suggest why IN clause…
The JSON data is as follows: I would like to count how many times each element in a collection, such as {"3467562849402896", "3467562861985809", "3465044211793921"}, has been used. The number of elements in the collection is not fixed and is an…
I have a tickets table with this info: ticket_id | user_id | used_at ---------------------------------------- xxx | xxx | datetime xxx | xxx | datetime xxx | xxx | datetime I want to get a list of all users who has…
I need to find those notifications that have the eventCode set to REFUND. Here is the object stored in the DB: { "target": "target", "method": "POST", "headers": { "x-forwarded-host": "x-forwarded-host", "x-real-ip": "x-real-ip", "x-forwarded-for": "x-forwarded-for", "x-forwarded-proto": "x-forwarded-proto", "host": "host", "connection": "connection",…
I have a table cab name value 1 PHP 1 1 PHP 2 1 PHP 0 2 LHL 0 3 GHG 3 3 GHG 2 I am looking to get the distinct cab and name plus how many values =0…
SELECT u.id FROM user u WHERE u.id IN (7, 11) if I have no results for the ids specified, I want to return all users, similar to this query : SELECT u.id FROM user u the difficulty and I want…