MySQL Forums :: Full-Text Search :: how to find particular string from text column


Advanced Search

how to find particular string from text column
Posted by: sunil divyeshvar ()
Date: May 24, 2010 02:14AM

hi all


i hv data like this in one text column.

|1st Assumable Loan:|Selling Agency:Yes|1st Balance:|1st Due:|
1st Assumable Loan:|Selling Agency:No|1st Balance:|1st Due:|


I need to find particular string like Selling Agency:Yes then hw should i search ?? like is not giving me exact distinct count.

shoud i use find_in_set ??

give me exact idea

thanks

Options: ReplyQuote


Subject Views Written By Posted
how to find particular string from text column 5936 sunil divyeshvar 05/24/2010 02:14AM
Re: how to find particular string from text column 3890 Rick James 05/25/2010 06:21PM
Re: how to find particular string from text column 3226 sunil divyeshvar 05/28/2010 01:24AM
Re: how to find particular string from text column 2349 Rick James 05/31/2010 11:27PM
Re: how to find particular string from text column 2156 sunil divyeshvar 05/31/2010 11:55PM
Re: how to find particular string from text column 4128 Rick James 06/01/2010 09:02PM


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.