You can use
(?=.*test)(?=.*long)
Source: MySQL SELECT LIKE or REGEXP to match multiple words in one record
More Related Contents:
- Regex lookahead, lookbehind and atomic groups
- How can I validate an email address using a regular expression?
- Regex Last occurrence?
- Regular expression to match string starting with a specific word
- Regular Expression Arabic characters and numbers only
- How to match, but not capture, part of a regex?
- Match linebreaks – \n or \r\n?
- Notepad++ incrementally replace
- How would I import YouTube Likes and Dislikes and a ratio from YouTube onto Google Sheets? [closed]
- What is the complexity of regular expression?
- RegEx to match full string
- MongoDB, performance of query by regular expression on indexed fields
- Find numbers after specific text in a string with RegEx
- Email validation using regular expression in JSF 2 / PrimeFaces
- Regex get domain name from email
- Regular expression for GB based and only numeric phone number
- Can’t escape the backslash in a regular expression?
- Google Sheets Formula for Extracting Domain From Website?
- Regular Expression for any number greater than 0? [closed]
- Eclipse, regular expression search and replace
- Using sed and grep/egrep to search and replace
- Remove square brackets from a string vector
- regex: find one-digit number
- Regular Expression – How to find a match within a match?
- How to change date format in sed?
- Regular Expression usage with ls
- Match parenthesised block using regular expressions in vim
- RegEx for allowing alphanumeric at the starting and hyphen thereafter
- Difference between regex quantifiers plus and star
- Finding and removing Non-ASCII characters from an Oracle Varchar2