a guest Jul 21st, 2019 69 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT id,name,iupac_name,inchi_key,molecular_weight,molecular_formula,exact_molecular_mass
  2.     FROM compound
  3.     WHERE name LIKE '%quer%'
  4.     OR iupac_name LIKE '%quer%'
  5.     OR inchi_key LIKE '%quer%'
  6.     OR inchi_key IN( SELECT inchi_key FROM compound_synonyms WHERE name LIKE '%quer%')
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand