Nostr 9d21505afe60a219fe0a20bec8a94ae0f0c2db9d35f286e34409986b7fd18649

id: 9d21505afe60a219fe0a20bec8a94ae0f0c2db9d35f286e34409986b7fd18649

id (bech32): note1n5s4qkh7vz3pnls2yzlv3222urcv9kuaxhegdc6ypxvxkl73seys9lqglw

sig: 58c1aaefaf795dd890c87aee90e3d08cf0b23681ab0a97547f2754610cb43e5b1f0556ba789411b5bcd3ef901a14ab5fe702f0397010962ac6de3eca75c63df3

created_at: 2023-09-02 21:37:04 +0900

created_at (unix time): 1693658224

content:

ActiveRecordでJSONカラムのcontentをLIKEで検索するNOTE

テーブル定義はnosdump-and-storeのそれ想定ね

NostrEvent.where("body::json->>'content' LIKE '%探し%'")