我想出了如何将下面的AND/OR/NOT布尔语句转换为兼容的MATCH AGAINST解决方案，并希望这对其他人有所帮助。
这将转换：

(word1 OR word2) OR (word3 AND word4 AND word5) OR word6 NOT word7

字符串
到

(WORD1 WORD2) (+WORD3 +WORD4 +WORD5) WORD6 -WORD7

型
产品编号：

SET in_text_search = '(word1 OR word2) OR (word3 AND word4 AND word5) OR word6 NOT word7';
SET text_reformatted = UCASE(TRIM(in_text_search));
SET text_reformatted = REPLACE(text_reformatted,'  ',' '); -- Strip extra spaces

-- Make sure the count of parentheses (if exist) is equal.
IF (INSTR(text_reformatted,'(') > 0 OR INSTR(text_reformatted,')') > 0) THEN
        SET count_character = LENGTH(text_reformatted) - LENGTH(REPLACE(text_reformatted,'(',''));
        IF (count_character <> (LENGTH(text_reformatted) - LENGTH(REPLACE(text_reformatted,')','')))) THEN
                -- TRIGGER ERROR 'imbalanced parentheses';
                LEAVE SP;
        END IF;
END IF;

SET text_reformatted = REPLACE(text_reformatted,' AND ',' +');
SET text_reformatted = REPLACE(text_reformatted,' OR ',' ');
SET text_reformatted = REPLACE(text_reformatted,' NOT ',' -');

-- Primary replace
SET text_reformatted = REGEXP_REPLACE(text_reformatted, '(?<![-+])\\b(\\w+)\\b(?=(?:\\s*\\+|\\s*$))', '+$1', 1, 0, 'c');

-- Cleanup the cart before the horse, for words like .NET etc.
SET text_reformatted = REPLACE(text_reformatted,'.+','+.');
SET text_reformatted = REPLACE(text_reformatted,'.-','-.');

型

在某种程度上，这个SQL风格的解决方案是为了好玩，但也许它会帮助一些人。

with RECURSIVE
  t1(in_text_search) as (
    values
      row('(word1 OR word2) and .net AND (word3 AND word4 AND word5) OR word6 NOT word7')
  ),
  r as (
    select
      0 as occ,
      cast('' as char(127)) as tok,
      in_text_search,
      0 as parentheses,
      cast('process' as char(30)) as status
    from t1
    union all
    select
      r.occ+1,
      case
        when t.tok = 'AND' then '+'
        when t.tok = 'NOT' then '-'
        when t.tok = 'OR' then ' '
        else coalesce(t.tok, '')
      end,
      r.in_text_search,
      p.parentheses,
      case
        when p.parentheses < 0 then 'imbalanced parentheses'
        when t.tok is null then
          case
            when p.parentheses != 0 then 'imbalanced parentheses'
            else 'done'
          end
        else 'process'
      end
    from r,
    LATERAL(
      select
        ucase(regexp_substr(
          r.in_text_search,
          '[()]|[^()[:space:]]+',
          1,
          r.occ+1
        )) as tok
    ) as t,
    LATERAL(
      select
        r.parentheses +
          case
            when t.tok like '(' then 1
            when t.tok like ')' then -1
            else 0
          end as parentheses
    ) as p
    where status = 'process'
  ),
  t2 as (
    select
      occ,
      tok,
      lead(tok, 2) over(order by occ) as tok_2nd,
      status
    from r
  ),
  t3 as (
    select
      occ,
      case
        when tok = '(' and tok_2nd in ('+', '-') then concat(tok, tok_2nd)
        when tok in ('+', '-') then concat(' ', tok)
        else tok
      end as tok,
      status
    from t2
  )
select
  GROUP_CONCAT(tok order by occ separator '') as text_reformatted
from t3
;

个字符
db<>fiddle