MySQL Forums
Forum List  »  Full-Text Search

Re: how to find particular string from text column
Posted by: sunil divyeshvar
Date: May 28, 2010 01:24AM

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.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: how to find particular string from text column
3744
May 28, 2010 01:24AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.