MySQL: Incrementing an Integer by 1 on SELECT Statement

Question

Is there a way to add 1 to an integer column on the SELECT statement? Something like:

$result = mysql_query('SELECT (counter + 1) from table...

Thanks.

If you mean you want to increment the actual column value in the database by the select: luckily, this is not possible. — The Nail
– The Nail, Commented Jan 15, 2012 at 13:31
Yes, tried it. I need the AS alias -- see @Michael 's answer below. — H. Ferrence
– H. Ferrence, Commented Jan 15, 2012 at 13:45

Michael Berkowski · Accepted Answer · 2012-01-15 13:30:01Z

1

SELECT (counter + 1) AS counter FROM table;

Just be sure to specify a column alias (AS counter) or it will be more difficult to use mysql_fetch_assoc()

answered Jan 15, 2012 at 13:30

Michael Berkowski

271k47 gold badges450 silver badges395 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Perfect. Worked with AS. Thanks @Michael!