How can SQL rlike match multiple keywords?

In SQL, RLIKE is the operator used for performing regular expression matching. If you want to match multiple keywords, you can use the | symbol to represent the “or” relationship. For example, if you want to match records containing either the keyword “apple” or “orange”, you can use the following syntax:

SELECT * 
FROM table_name
WHERE column_name RLIKE 'apple|orange';

This will match records containing either “apple” or “orange”. To match more keywords, simply add more keywords to the regular expression and separate them with the | symbol.