+--------------+-------------+--------------------------------+--------------------------+--------------------------+ | text | shouldMatch | text RLIKE '[[:<:]]35[[:>:]]-' | text RLIKE '[^0-9]*35->' | text RLIKE '[^0-9]+35->' | +--------------+-------------+--------------------------------+--------------------------+--------------------------+ | 35->0|22->0 | 1 | 1 | 1 | 0 | | 435->0|22->0 | 0 | 0 | 1 | 0 | | 22->0|35->0 | 1 | 1 | 1 | 1 | | 22->0|235->0 | 0 | 0 | 1 | 0 | +--------------+-------------+--------------------------------+--------------------------+--------------------------+