Search/Edit the Chemicals Database: One Clause

SELECT * FROM chemicals WHERE

MATCH Options

The most common MATCH option is *stuff*, which finds "stuff" no matter where it is in the field. This is the sort of match that QuickSearch uses. 

?  Matches any single character
*  Matches zero or more arbitrary characters
[xyz]  Matches x or y or z
[a-z]  Matches anything in the alphabet
[^az]  Matches anything except a or z
{...}  Like *, except matches only the described characters
       e.g., {[0-9]} matches any collection of numbers
\?     Matches a real ?; \[ matches a real [ , etc

examples:

[0-4]4[0-4]* finds flamable HMISs
*Methy*Acid  finds any name in which methy precides the final
             word acid, possibly with something before the methy