How to remove all bookmarks from the database?

Question

PHP

Hello. This query displays all bookmarks of an authorized user:

$user_id = intval($_GET['user_id']);
$USER = $db->super_query("SELECT * FROM " . USERPREFIX . "_users WHERE user_id='{$user_id}' ");
echo $USER['favorites'];

Help build a query that clears the value of 'favorites'

Answer 1

Of course, you need to check whether the user is the owner of the bookmarks.
Something like:

$user_id = intval($_GET['user_id']);
if ((int)$member_id['user_id'] === $user_id ) {
    $db->query( "UPDATE `" . USERPREFIX . "_users` SET `favorites`='' WHERE `user_id`='{$user_id}'" );
}

Answer 2

$USER = $db->super_query("UPDATE TABLE" . USERPREFIX . "_users SET favorites='' WHERE user_id='{$user_id}' ");
??