[EP-tech] Re: search for 2-character-string

Thomas Lauke th.lauke at arcor.de
Fri Oct 2 17:15:37 BST 2015


> Could you give a little more context?
we like to realize something similar to

mysql> select * from eprint_system where system like '%na%';
+----------+-----+-------------------------+
| eprintid | pos | system                  |
+----------+-----+-------------------------+
|     6550 |   0 | binary oceanic          |
|     8468 |   7 | Na-p-Toluensulfonat-H2O |
|     8468 |   6 | Li-p-Toluensulfonat-H2O |
:

but want to search for 'na-%' likewise ...

Currently just a search for the complete system string, like
'Item Status matches any of "User Workarea", "Under Review", "Live Archive" AND System is "binary oceanic"',
is successful ...

Thanks in advance
Thomas


More information about the Eprints-tech mailing list