Search witin text.

Hi, I have to send results to the users based on their search. Have got a combined serach option in which data is searched from two different fields and based on the match the result is sent or an error message (quite simple). Now I need to change this, the one column of data is from a VARCHAR field and have to seach for a perticular text from another column that is TEXT. So there could be data like "Apparel | Footwear | Toys | Watches". If the data matches the "Toys" the result is sent. The issue I have is quite simple, its not working. Is there anything special that needs to be done with the TEXT column? Please advice, many thanks. Chris -- View this message in context: http://www.nabble.com/Search-witin-text.-tf3207710.html#a8907729 Sent from the Php - Database mailing list archive at Nabble.com.