I have this table in mysql
id | chat_id | name | grade | photo | phone
-------------------------------------------
1 | 1344564 | mikel | | |
so I want to select all empty fields(grade,photo,phone) in a single code line at specific condition
Aasif khan :
SELECT * FROM exampletable WHERE chat_id="1344564" AND (grade IS NULL) OR (photo IS NULL) OR (phone IS NULL)",
2017-12-01T14:19:47
Amit Gupta :
You can update grade, photo and phone in your query like below:\n\nAND (grade = \"\" OR grade IS NULL)\n",
2017-12-01T13:51:17