Re: Querying

[Russell Dyer]

You didn't say which programming language API (PHP, Perl, etc.) you want to use to do this. However, at the core of whatever interface you create, you would use an UPDATE statement with a WHERE clause. It would look like this:

UPDATE table1
SET price = price * 1.1
WHERE products LIKE 'brx%';

This statement will take the current value of the column price and multiply it by 1.1 (i.e., 110%) and then set the price to that calculated value, but only where rows are found to have a product name beginning with the letters brx.

Russell Dyer

Author of "MySQL in a Nutshell" (O'Reilly 2005).