I would like to search for the percentage sign, %, in a text field. Is there an escape character I can use to disable the symbol's wildcard properties?
Instant JChem Version: 5.3.4 (build: 100615)
JChem Table Version: 5030300
5.3.4 (build date: 2010-06-15)
Java: 1.6.0_18; Java
HotSpot(TM) Client VM 16.0-b13
System: Windows XP version 5.1
running on x86; Cp1252; en_US (instantjchem)
It seems that this is not possible at present.
SQL does provide such a mechanism by specifying an escape character using a syntax like this:
SELECT name FROM emp WHERE id LIKE '%/_%' ESCAPE '/';
But IJC does not provide a way to specify the escape character.
Hoewever if you are uisng a MySQL database it seems that you are lucky as the backslash character is provided as the default escape character, so to find a value like 37% in a text field you can enter the term like this:
But if you are using a Derby local database or an Oracle database then you are out of luck.