Re: how to find particular string from text column

[sunil divyeshvar]

Hi

thanks for reply.

please tell me what is the exact syntax ??

select * from TABLENAME where COLUMNNAME
RLIKE '(^|\|)Selling Agency\s*:\s*Yes(\||$)'; ??????


I am searching now other word i.e. SEWER:Septic

SEWER:Septic
RLIKE '(^|\|)SEWER\s*:\s*Septic(\||$)'

Word is there in particular column bt i still found following error:

Error Code : 1139
Got error 'empty (sub)expression' from regexp
(0 ms taken)

Please reply.