[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