What query language is this?

  • Thread starter Stephen Tashi
  • Start date
  • Tags
In summary, the advanced search tutorial on publicnoticeads.com says that the With at least one of these words field can have multiple words and the search will find notices that have anyone word, some of the words or all the words. However, the interface appears to not work this way.
  • #1

Stephen Tashi

Science Advisor
I'm trying to figure out how to use the search interface on publicnoticeads.com. In the "advanced" search screen the field "With at least one of these words" does not work correctly. It appears to require all the words you list.

For example if I set state to be NM, the county to be Dona Ana, the keyword to be "foreclosure" and the "With at least one of these words" to be "Idaho", I get some hits. However, if I put "Idaho Missouri" in that field, I get zero hits.


That query gives the message:
You searched for: county:Dona|Ana|foreclosure+(Idaho|Missouri)
Is this the syntax of some query language? Is there a way to trick the interface into working properly?


  • pubnoticesearch.jpg
    32.7 KB · Views: 592
Computer science news on Phys.org
  • #2
That looks like a Boolean expression generated from the input form. It is doubtful you can access anything at that level. At least it indicates what it makes of the freeform inputs.

| = OR
+ = AND
() works to group expressions
: = ?

  • #3
Did you click the link that says " View Search Tutorial"?
  • #4
The advanced search tutorial says
-- 'With at least one of these words': This field can have multiple words and the search will find notices that have anyone word, some of the words or all the words.
which is not how the interface appears to work.
  • #5
  • #6
I am not surprised. Many websites have a stupid interface to their database queries - they just string all the search queries together (which means an implied "and") and send it to the database Of course you get a very small number of hits. The only thing worse is when stringing all the search queries together means an implied "or" (and you get a large amount of hits, making the query useless).

Most people are used to Google which has a very intelligent approach to search queries - people using Google do not mind getting 20 000 hits because what they are looking for is usually on the first page.

1. What is a query language?

A query language is a specialized programming language designed for querying and manipulating data stored in databases. It is used to retrieve, insert, update, and delete data from a database management system.

2. What are the most common query languages used in databases?

The most commonly used query languages in databases are SQL (Structured Query Language) and NoSQL (Not only SQL). SQL is used in relational databases, while NoSQL is used in non-relational databases.

3. How does a query language differ from a regular programming language?

A query language is designed specifically for interacting with databases, while a regular programming language is more general and can be used for various applications. Query languages have a limited set of operations and are optimized for data retrieval and manipulation, while regular programming languages have a broader set of functions and are used for creating applications.

4. Can you give an example of a query language in action?

Sure! Here is an example of a SQL query: SELECT * FROM Customers WHERE Country='USA'. This query would retrieve all customer data from the "Customers" table in a database where the country is listed as "USA".

5. Are there any other query languages besides SQL and NoSQL?

Yes, there are other query languages such as XQuery, SPARQL, and GraphQL. These languages are used for specific types of databases, such as XML databases, graph databases, and APIs, respectively.

Suggested for: What query language is this?