Wildcard search

Contribute Feature
6

On a small enough site something like this could work:

-- [params]
-- string :query

SELECT p.id AS post_id, 
       p.user_id
FROM posts p
WHERE p.raw ~* :query
  AND p.deleted_at IS NULL

Though you could maybe add a specific category or date range if you wanted to limit it further.

Once written, you can make it available to certain groups to use:

query available to groups
query available to groups1390×516 17.6 KB

Though I appreciate it working from the Search bar is ideally what the OP is after. :slight_smile: I’ll slide this over to Contribute > Feature in case there’s more demand for it.