ALTER TABLE `lc_bookmarks` ADD COLUMN `is_miscellaneous` TINYINT NOT NULL DEFAULT '0';



UPDATE lc_bookmarks SET bookmark_name='Miscellaneous Tags' WHERE bookmark_name='Other Tags';
UPDATE lc_bookmarks SET status=1 WHERE parent_id=(SELECT lcb.id FROM (SELECT * FROM lc_bookmarks) AS lcb WHERE bookmark_name='Miscellaneous Tags');
UPDATE lc_bookmarks SET is_miscellaneous = 1 WHERE parent_id=(SELECT lcb.id FROM (SELECT * FROM lc_bookmarks) AS lcb WHERE bookmark_name='Miscellaneous Tags');
UPDATE lc_bookmarks SET query="select tag_data from lc_uploader_tags_data where emp_id='{id}' and bookmark_id='{bookmark_id}' order by id desc limit 1;"
WHERE parent_id=(SELECT lcb.id FROM (SELECT * FROM lc_bookmarks) AS lcb WHERE bookmark_name='Miscellaneous Tags');



