[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[EP-tech] Re: search for 2-character-string
- Subject: [EP-tech] Re: search for 2-character-string
- From: th.lauke at arcor.de (Thomas Lauke)
- Date: Fri, 2 Oct 2015 18:15:37 +0200 (CEST)
- References: <2052537855.58046.1443794602141.JavaMail.ngmail@webmail18.arcor-online.net> <984273789.757419.1443184553811.JavaMail.ngmail@webmail16.arcor-online.net>
> 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