Re: Search witin text.
| From: | Micah Stevens | Date: | Sun, 11 Feb 2007 05:20:39 +0000 |
| Subject: | Re: Search witin text. | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-43057@lists.php.net to get a copy of this message | ||
Send your query out on the list. That would give us something to work on. This should be very easy..
select * from tablename where column like '%$search%'
or something of that nature. What are you doing?
-Micah
On 02/10/2007 08:49 PM, Chris Carter wrote:
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