DELETE FROM moz_historyvisits
WHERE place_id IN (
SELECT id
FROM moz_places
WHERE url
LIKE '%misskey.xyz%'
)
で~きた #ijs_memo
DELETE FROM moz_historyvisits
WHERE place_id IN (
SELECT id
FROM moz_places
WHERE url
LIKE '%misskey.xyz%'
)
で~きた #ijs_memo
早とちりで3回間違えた
これで、指定した文字列を含むURLの履歴を自動で全消しできるぞっ!
senooken JP Social is a social network, courtesy of senooken. It runs on GNU social, version 2.0.2-beta0, available under the GNU Affero General Public License.
All senooken JP Social content and data are available under the Creative Commons Attribution 3.0 license.