Help for this page

Select Code to Download


  1. or download this
    SELECT words.id, words.definition
      FROM words 
    ...
    WHERE stock.word = ? 
      AND languages.name = ? 
      AND types.name = ?
    
  2. or download this
    SELECT words.id, words.definition
      FROM words 
    ...
      JOIN stockmatch ON words.id = stockmatch.wordID
      JOIN stock ON stockmatch.stockID = stock.id AND stock.word = ?
      JOIN languages ON stock.languageID = languages.id AND languages.name
    + = ?