When I run a delete SQL command in the ubbt_POSTS table, will everything still be fine afterwards?

Like for example when I run this command, will all te other posts still display correctly?

delete from ubbt_POSTS where POST_POSTER_NAME='username'