Sometime we would like to add a string in the beginning of a string value, an example is to add a “6” in front of all the contact numbers.
Here the simple way to use SQL statement.
UPDATE thetablename SET thecolumnname=CONCAT(‘6’,thecolumnname);
To make the statement even smarter to ignore value that already have a “6”.
UPDATE thetablename SET thecolumnname=CONCAT(‘6’,thecolumnname)
WHERE thecolumnname NOT LIKE ‘6%’;
Sometimes the VestaCP SSL Certificate didn’t get auto-renew, so you might need to run the command
VestaCP released the new version 1.0, but it contains a lot of bugs that caused Letsencrypt
An aero wheelset is one of the fastest upgrades for your bike. In this video I’ll
An aero wheelset is one of the fastest upgrades for your bike. In this video, I’ll
Wondering whether worth buying China-made Carbon Wheelsets? After setting up the new Winspace Hyper wheelsets, I
