SQL (Structured Query Language) is a standard programming language for relational database management systems (like our library database system). SQL statements allow you to retrieve data from a database.
In our Advance Search you can easily and quickly build search queries, to do that, you don't have to know SQL language.
Our library Advanced Search provides interface that allows you to define simple search condition. In the case of complex search definitions it will be easier to enter the search condition directly into the Search Condition box. Below we list some library search samples with SQL functions and ready to use statements. If you have questions how to define other library useful searches/queries please contact us.
CURRENT_DATE returns the current date value, use this function with other library database date fields.
Compare item DATE_ADDED value with the CURRENT_DATE to display library items that were added today, yesterday, or in the last week or month.
Copyright © 2019 · All Rights Reserved · PrimaSoft PC