Soundex stuff from iREIT

  Snippets, MySQL snippets

Various crap.

SELECT
  d.id,
  d.name
FROM ireit_analysis.v_ireit_house d,
  ireit_reference.dictionary_newage r
WHERE d.name REGEXP r.word
    AND ( r.word LIKE '%finance%' || r.definition LIKE '%finance%' || r.word LIKE '%bank%' || r.definition LIKE '%bank%' || r.word LIKE '%money%' || r.definition LIKE '%money%');
SELECT
  d.id,
  d.name
FROM ireit_analysis.v_ireit_house d
WHERE d.name STRCMP(SELECT
                      r.word
                    FROM ireit_reference.dictionary_newage r
                    WHERE r.word LIKE '%finance%');
SELECT
  d.id,
  d.name
FROM ireit_analysis.v_ireit_house d
WHERE d.name sounds LIKE 'b';
SELECT
  difference('gokarts','gocart');
SELECT
  d.id,
  d.name
FROM ireit_analysis.v_ireit_house d
WHERE INSTR(SUBSTR(SOUNDEX(CONCAT('Z',d.name)), 2), REPLACE(SUBSTR(SOUNDEX('Zbird'), 2), '0', '')) > 0;
SELECT
  d.id,
  d.name
FROM ireit_analysis.v_ireit_house d
WHERE INSTR(SUBSTR(SOUNDEX(d.name), 2), REPLACE(SUBSTR(SOUNDEX('auto'), 2), '0', '')) > 0;
SELECT
  SOUNDEX('z0portal.com'),
  SOUNDEX('zbird');