I would like to ask how to use flask sqlalchemy to query multiple conditions, and some conditions can be empty, you can still query other conditions.

the problem encountered at present is that when there are multiple conditions in filter Filter, if some conditions are null, it will cause many other conditions to have values but cannot be queried.

Jan.08,2022
MySQL Query : SELECT * FROM `codeshelper`.`v9_news` WHERE status=99 AND catid='6' ORDER BY rand() LIMIT 5
MySQL Error : Disk full (/tmp/#sql-temptable-64f5-1bebb31-39e47.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
MySQL Errno : 1021
Message : Disk full (/tmp/#sql-temptable-64f5-1bebb31-39e47.MAI); waiting for someone to free some space... (errno: 28 "No space left on device")
Need Help?