How do I write up an SQL query to run from Admin Panel?

[GumboStandards]

I use the following SQL query successfully from within phpMyAdmin's SQl query window:

UPDATE live_products_description SET products_description = REPLACE (
products_description,
'OldKeyword',
'NewKeyword');

When I try to run the same from Admin Panel > Tools > Install SQL Patches I get the following error message:

Failed: 1
ERROR: Cannot execute because table live_products_description does not exist. CHECK PREFIXES!
Note: 1 statements ignored. See "upgrade_exceptions" table for additional details.

What do I need to adjust so that my client can run it directly from Zen Cart's Admin Panel?

Thanks.

[swguy]

UPDATE products_description ...

the live_ is taken care of for you by the SQL Patches Tool.

[GumboStandards]

That's it?! Oh, wow, thank you so much.

[GumboStandards]

Oh, so "check prefixes" doesn't refer to prefixes' spelling but way too subtly hints at their removal. Got it now. Thanks, again.

[mc12345678]

Oh, so "check prefixes" doesn't refer to prefixes' spelling but way too subtly hints at their removal. Got it now. Thanks, again.

While the issue occurs more commonly as attempted above, it generally applies to any table. Older code/improperly developed code does not include the DB_PREFIX as part of the table generation. Therefore, the prefix may be properly prepended to a table but the table then not exist... It's kind of a total inspection/check but should be approached from the knowledge that swguy has shared.