Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Rewrite sections "Filtering" and "Building more complex queries" #36

Open
steltenpower opened this issue Jun 1, 2017 · 0 comments
Open

Comments

@steltenpower
Copy link
Contributor

steltenpower commented Jun 1, 2017

02-basic-queries SAYS:

Databases can also filter data – selecting only the data meeting certain criteria. For example, let’s say we only want data for a specific ISSN for the Theory and Applications of Mathematics & Computer Science journal, which has a ISSN code 2067-2764|2247-6202. We need to add a WHERE clause to our query:

SELECT *
FROM articles
WHERE issns='2067-2764|2247-6202';

But 2067-2764|2247-6202 is not a ISSN code, it's a combination of 2 (pipe-separated).
In case you want to match both at the same time this is not the way, cause

  • in a row of the table they might be ordered differently within the field
  • these 2 could be among 3 or more
    If you're also looking for 1 of the 2 matched, this query wouldn't return them either.

First focus on fields that have 1 entry, perhaps ?

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants