Description:
------------
PHP will not successfully execute the RIGHT() command in 
a mysql_query(). It executes successfully, affects 1 
row, but doesn't actually substring the field from the 
right. The same query works, directly in MySQL, but not 
through the mysql_query() offered in PHP.

Example: UPDATE sales SET ccnum=RIGHT(ccnum,4) WHERE 
ID=3301 LIMIT 1

Reproduce code:
---------------
$sql="UPDATE sales SET ccnum=RIGHT(ccnum,4) WHERE ID=$ID LIMIT 1";
$results = mysql_query($sql);

Expected result:
----------------
It should shorten the ccnum field to 4 characters 
starting at the right. Others have suggested just using 
the SUBSTRING() mysql command, but that doesn't work 
from the right, which is what I need.

Actual result:
--------------
Executes without error, but doesn't shorten the string.