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');