Re: how to find particular string from text column

[Rick James]

See if this works better.
RLIKE '(^|[|])SEWER\s*:\s*Septic([|]|$)'
Remove the two "\s*" if there can never be spaces in those places.

Usually this will work correctly and run somewhat faster:
LIKE '%SEWER:Septic%';

The difference would come with
...|SEWER : Septic|... -- my RLIKE will catch it (correctly?), LIKE won't
...|SEWER:SepticTank|... -- RLIKE skips it (correctly?); my Like won't.
...|FOOSEWER:Septic|... -- RLIKE skips it (correctly?); my Like won't.

But, really, you ought to rethink this text field. Read about SETs, ENUMs. Such as
SEWER ENUM(unspecified, Septic, City, County) NOT NULL