Remove spaces

[prokhaled]

There is any function to remove spaces from MySql Database

for example:

I Have thsi data

ID Word
1 Hi
3 bye
4 now
6 go

I want to remove spaces.

Output:

ID Word
1 Hi
2 bye
3 now
4 go

[scoutt]

I don't see what you are talking about. and don't you ever read teh manual??

look into str_replace()

[prokhaled]

I mean reNumber the rows of table

[The Hobo]

scoutt and I had a big discussion on this once, go search for it.