mysql uses where MATCH (column) AGAINST ("string" mode) as documented here https://dev.mysql.com/doc/refman/8.0/en/fulltext-search.html
pgsql uses (i think) where to_tsvector(column) @@ to_tsquery("string") from what i can tell from the completely incomprehensible docs https://www.postgresql.org/docs/current/textsearch-intro.html