Implement a multi-criteria query to match multiple data in a database field

Select ' T.symptom like ' | | ' Or ' | | REPLACE ('% ' | | Replace (replace (' 1,2,4 ', ', ', ', '% '), ', ', ', ') | | ' % ', ', ', ', '% ' or t.symptom like ') as TH from dual;

' 1,2,4 ' for the field value to be replaced t.symptom the matching column in the corresponding table has been tested with the need to match the string into an executable SQL statement function, otherwise it cannot be used directly in the database. The resulting string can be injected into the query SQL through the foreground, or the character to be replaced by the JS will replace the replacement and then there is a way to write ' regexp_like ' for the foreground of the value passed in (' "", '? ')

Implement a multi-criteria query to match multiple data in a database field