let the database do the heavy lifting
fix typos
strip the url