how to Update guid = "text"+post_name?

in phpmyadmin, i use this SQL command to update all posts that have guid like '%/?p=%' = https:/bkfast.vn/+post_name

update lgs_posts set guid='https://bkfast.vn''post_name' where guid like '%/?p=%'

But it's error: Truncated

Pls help me update all posts that have guid like '%/?p=%' = https:/bkfast.vn/+post_name

Old: https://bkfast.vn/p=2258 - New: https://bkfast.vn/ky-thuat-trong-rau-thuy-canh-tinh

Info: post_name varchar(200); guid varchar(255)