Upgrade StorageRemoval of certain tags
Hello,
I have a number of tags which I want to get rid of. Valid tags are of a length of 4, every other tag is considered unvalid.
I opened the SQLite database with sqlbrowser. I was able to delete the last entry in the table "tags" with the delete-button, but tags which are in the middle of the table would not vanish.
I also tried the following line with no result:
"delete from tags where length(tags.name) <> 4"
To find out if the construction works I used
"select * from tags where length(tags.name) <> 4", and all tags longer or shorter than 4 characters showed up. But the delete command did not work...
What was done wrong?
Thanks for answering, Richard
I have a number of tags which I want to get rid of. Valid tags are of a length of 4, every other tag is considered unvalid.
I opened the SQLite database with sqlbrowser. I was able to delete the last entry in the table "tags" with the delete-button, but tags which are in the middle of the table would not vanish.
I also tried the following line with no result:
"delete from tags where length(tags.name) <> 4"
To find out if the construction works I used
"select * from tags where length(tags.name) <> 4", and all tags longer or shorter than 4 characters showed up. But the delete command did not work...
What was done wrong?
Thanks for answering, Richard
This is an old discussion that has not been active in a long time. Instead of commenting here, you should start a new discussion. If you think the content of this discussion is still relevant, you can link to it from your new discussion.