Advertisement
Guest User

Untitled

a guest
Jul 21st, 2019
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.29 KB | None | 0 0
  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%')
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement