select *
from location_csv as lc 
where lastname = ''

UPDATE location_csv 
SET lastname = NULLIF(lastname, '')

downloadDownload PNG downloadDownload JPEG downloadDownload SVG

Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!

Click to optimize width for Twitter