You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
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 ?
The text was updated successfully, but these errors were encountered:
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
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 ?
The text was updated successfully, but these errors were encountered: