Skip to content

Home
Deliveries & Changes
Aircraft
Fleet
Countries
Types
North Atlantic Tracks
Privacy Policy

Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy

Menu

Home
Deliveries & Changes
Aircraft
Fleet
Countries
Types
North Atlantic Tracks
Privacy Policy

Powered by Verbosa & WordPress.

Home MySQL mySQL trim leading zeros

mySQL trim leading zeros

January 17, 2020 January 17, 2020

UPDATE table SET column= TRIM(LEADING '0' FROM column) WHERE column LIKE '0%'

Share this:

Click to share on Twitter (Opens in new window)
Click to email a link to a friend (Opens in new window)

Like this:

Like Loading...

Related

Previous PostThursday, 16th Jan

Next PostFord GT: The Return to Le Mans

Aircraft Status (Seen)

Less than 1 day ago

Less than 7 days ago

Less than 14 days ago

Less than 80 days ago

More than 80 days ago

Top Posts & Pages

Aircraft
Countries
Deliveries & Changes
North Atlantic Tracks

Tags

A20N A21N A319 A320 A321 A332 A333 A359 B38M B39M B77W B350 B733 B737 B738 B763 B789 BCS3 BE9L BE20 C25B C25C C56X C208 C525 C560 CL30 CL60 E55P E75L F2TH F900 FA7X G280 GA6C GL7T GLEX GLF4 GLF5 GLF6 H25B LJ45 PC12 PC24 TBM9

Meta

Log in
Entries feed
Comments feed
WordPress.org

%d