[thelist] mysql - like

[Chris Price]

I'm glad you asked me that.

I've changed it to text and it works fine now.

Thanks very much.

The next thing is searching on phrases so that if a search is made on 
'this word' results are returned for 'this' or 'word'. Do you know any 
good resources for this stuff.

--
Chris Price

On Thursday, August 24, 2006, at 07:09  am, Anthony Baratta wrote:

>> The field is a blob type. I just checked it on a varchar field and it
>> worked OK.
>
> There ya go! BLOB - *Binary* Large Object. That's gonna be 
> case-sensitive.
>
> Why are you storing text data in a BLOB??