summaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorMunyoki Kilyungi2023-04-03 11:33:27 +0300
committerMunyoki Kilyungi2023-04-03 11:33:27 +0300
commited011383b14ac5340653cb7cbca569ba237e8d6c (patch)
tree7b78259ee52a7b87eec6cb6cec1a0dde73655784
parent81ad6cb2a0d0cff9aa4d8c8a698ed08fdf4f67a7 (diff)
downloadgn-gemtext-ed011383b14ac5340653cb7cbca569ba237e8d6c.tar.gz
Update query for demo'ing rows with an empty symbol
Signed-off-by: Munyoki Kilyungi <me@bonfacemunyoki.com>
-rw-r--r--issues/dump-genewiki-metadata.gmi5
1 files changed, 3 insertions, 2 deletions
diff --git a/issues/dump-genewiki-metadata.gmi b/issues/dump-genewiki-metadata.gmi
index 37786b6..b727e26 100644
--- a/issues/dump-genewiki-metadata.gmi
+++ b/issues/dump-genewiki-metadata.gmi
@@ -62,8 +62,9 @@ SELECT * FROM GeneRIF_BASIC WHERE symbol = 'NEWENTRY'\G
("–" . "-"))
```
-* In the GeneRIF_BASIC table, there are rows with an empty symbol (empty string instead of NULL):
+* In the GeneRIF_BASIC table, there are 14,313 rows with an empty symbol:
+
```
-SELECT * FROM GeneRIF_BASIC WHERE TaxID=139 AND GeneId = 13917590 AND PubMed_ID = 23692497\G
+SELECT COUNT(*) FROM GeneRIF_BASIC WHERE symbol = '';
```