# Crazy MySQL statement, change display

**URL:** <https://forum.kirupa.com/t/crazy-mysql-statement-change-display/204442>\
**Category:** Uncategorized\
**Created:** [October 19, 2006, 8:12pm UTC](https://forum.kirupa.com/t/crazy-mysql-statement-change-display/204442 "2006-10-19T20:12:24Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![JoshuaJonah](https://yyz1.discourse-cdn.com/flex011/user_avatar/forum.kirupa.com/joshuajonah/32/1775_2.png) [@JoshuaJonah](https://forum.kirupa.com/u/JoshuaJonah)\
**Post date:** [October 19, 2006, 8:12pm UTC](https://forum.kirupa.com/t/crazy-mysql-statement-change-display/204442/1 "2006-10-19T20:12:24Z")

</div>

I have a database

## Websites Hits

1 300  
2 200  
3 500  
4 300

(this is obviously hypothetical;))

## now, i want to display it as: Websites Hits

1 400  
2 200  
3 500  
4 300  
see how it adds 100 to a specific website with just a select statement, i dont want to actually change the dbase.

Any ideas?
