Please help im stuck mysql problem

I need to change all entrys in the url colum to be the same and i just dont know how, there are 25,000 so i cant do it one at a time.

I have attatched a pic if it helps

Please help

Thanks

 

Why can't you do it all at once? This query will do it:

UPDATE shorturl_short SET url='insert url value here';

 

Thanks plog exactly what i needed spot on

 

Is is also posible to spesify a range of rows or only replace rows that contain a certain word

 

User WHERE statement:

 

Many Thanks