Search notes:

SQL: WHERE clause

Special precaution needs to be taken when using a where condition with the = or <> operator on an approximate numeric data type is performed.

See also

Much as the SQL where clause is used to specify on which records an SQL operation is peformed, the select-object cmdLet is used to specify which PowerShell-objects are kept in a PowerShell pipeline.
In Excel, a worksheet's autoFilter object allows to filter rows based on the values of its cells.
The worksheet function filter also allows to select portions of a range that match a certain criteria.
The MS-Access method DoCmd.SetOrderBy.
SQL precedence (AND, OR)

Index

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1737228045, '3.133.136.117', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/SQL/where/index(48): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78