search

usememos / memos

An open source, lightweight note-taking service. Easily capture and share your great thoughts.
https://usememos.com
MIT License
30.3k stars 2.27k forks source link

Search by tag does not work with MySQL #3841

Closed joshefin closed 2 weeks ago

joshefin commented 3 weeks ago

Describe the bug

The json_contains function should be used in the following way:

select json_contains('["tag1","tag2","tag3"]', '["tag1"]');
select json_contains('["tag1","tag2","tag3"]', '["tag1","tag3"]');

Steps to reproduce

Select any tag in the UI to filter the memos. No results are shown.

The version of Memos you're using.

v0.22.4

Screenshots or additional context

No response

boojack commented 2 weeks ago

Duplicated with https://github.com/usememos/memos/issues/3756