Steps to update sh404 to perform 301 redirects on Joomla from the database

gistfile1.txt

-- Steps to update sh404 to perform 301 redirects on Joomla from the database

-- 1. Search for your current url
select * from {owner}.{prefix}sh404sef_urls 
where oldurl like '%{your old url}%'
order by oldurl
-- 2. Update the newurl to the new page you want
index.php?option=com_content&Itemid={menu item id}&id={article id}&lang=en&view=article

update {owner}.{prefix}sh404sef_urls 
set oldurl = '{your new url to redirect to}' 
where id={your matching item}

-- 3. from joomla admin delete existing alias if present
-- 4. from joomla admin add alias