note 104935 added to mysqli-stmt.bind-param

MySQL has a "NULL-safe equal" operator (I'm guessing since 5.0) http://dev.mysql.com/doc/refman/5.0/en/comparison-operators.html#operator_equal-to If you use this operator instead of the usual = you can interchange values and null in where clauses. There is however a known bug when using this operator with datetime or timestamp fields: http://bugs.mysql.com/bug.php?id=36100 ---- Server IP: 69.147.83.197 Probable Submitter: 78.23.245.6 ---- Manual Page -- http://www.php.net/manual/en/mysqli-stmt.bind-param.php Edit -- https://master.php.net/note/edit/104935 Del: integrated -- https://master.php.net/note/delete/104935/integrated Del: useless -- https://master.php.net/note/delete/104935/useless Del: bad code -- https://master.php.net/note/delete/104935/bad+code Del: spam -- https://master.php.net/note/delete/104935/spam Del: non-english -- https://master.php.net/note/delete/104935/non-english Del: in docs -- https://master.php.net/note/delete/104935/in+docs Del: other reasons-- https://master.php.net/note/delete/104935 Reject -- https://master.php.net/note/reject/104935 Search -- https://master.php.net/manage/user-notes.php