Quote Originally Posted by mc12345678 View Post
The query needs to be executed in a tool such as phpmyadmin in the cPanel of your site. There are other similar tools.

So, to be sure to offer a query that is likely to target just the desired product uri, please identify the vaUe of DB_PREFIX identified in YOUR_ADMIN/includes/configure.php where YOUR_ADMIN is the renamed admin directory used to access the admin side.
We ran the query from phpmyadmin and it says it was successful, however we still can't find the results. Talked with our hosting tech support and they said the results should display right after the query is run but they do not. We used your code from above, mc, inserting the proper DB_PREFIX identified in both configure.php files. So as a hypothetical example, if we want to use "flowers" as a category name, which had been previously created and then deleted but is still not being "released" due to a mapping conflict, this is the query executed:

SELECT uri FROM (our DB_PREFIX)_ceon_uri_mappings WHERE uri like '%flowers%';

Is this correct and where would the query results be located? Sorry this is taking much longer than expected, really appreciate your help!