Matty-kun on Nostr: I mean sure if you wanted to do that, you could: UPDATE instances SET favicon = ...
I mean sure if you wanted to do that, you could:
UPDATE instances SET favicon = '<
https://domain.tld/icon.png>'; WHERE host != 'yourdomain.tld';
But that would be silly. I’m not sure if != is the correct syntax for SQL “not equal to” statements though.
Published at
2023-05-22 01:25:35Event JSON
{
"id": "f3221f5dbf9db9460631087f4c415b51dfed41330c71cd985318709276b15c0d",
"pubkey": "8b347916be2cb3ab9687c9eb78a8d05224c045bce5b416bdd50169965eb0f45c",
"created_at": 1684718735,
"kind": 1,
"tags": [
[
"p",
"203bd46f9e4c676076dcfb143477e78d09e194c4b5e919c22647d3afd1ef1485",
"wss://relay.mostr.pub"
],
[
"p",
"79c4b3e2b1e7d8d74fa652cdc1dee37f9cd08fefdc13a79f8d1146c0b69fd1fb",
"wss://relay.mostr.pub"
],
[
"p",
"ac691c3499196b3103f8e6b571741b4a7b2d73c2c6f681e71cd975febae76c12",
"wss://relay.mostr.pub"
],
[
"e",
"01dfbd41e6ca69142d0440af59049b816810d706dd051ed9ed6a15a30ee957fc",
"wss://relay.mostr.pub",
"reply"
],
[
"mostr",
"https://nicecrew.digital/objects/64b8f4b9-e736-4187-87a3-f6fb625fcf05"
]
],
"content": "I mean sure if you wanted to do that, you could:\n\nUPDATE instances SET favicon = '\u003chttps://domain.tld/icon.png\u003e' WHERE host != 'yourdomain.tld';\n\nBut that would be silly. I’m not sure if != is the correct syntax for SQL “not equal to” statements though.",
"sig": "62e23656988f3bbcee5aa6a42e56220be4b90c6d9916cd5d205a11f127d897540d445537f4259fa0075befbb416025ed0231054518d4a74b144fb366bfc5a2da"
}
