Posted by Gene Kelley on 01/12/08 02:54

paul814@excite.com wrote:
> On Jan 7, 12:39 pm, paul...@excite.com wrote:
>> On Jan 7, 12:33 pm, "Paul Lautman" <paul.laut...@btinternet.com>
>> wrote:
>>
>>
>>
>>> paul...@excite.com wrote:
<...>
> I think I fixed this by going from this:
> $sql = "SELECT * FROM EDITORIAL WHERE editorialcomments LIKE '$Search
> %' ";
>
> to this:
> $sql = "SELECT * FROM EDITORIAL WHERE editorialcomments LIKE '%$Search
> %' ";
>
> And I think this fixed my initial problem, question

Yep. You got it. I would only add that, for performance reasons, I'd
recommend that the editorialcomments column is being indexed. These
"fuzzy" searches, that use the % in the clause tend to be much slower.
As well as the fact that text (varchar()) columns are slower even if an
explicit clause were used.

--

Gene Kelley
Senior Open Source Software Engineer
Advanced Design Solutions Team
Network Solutions (MonsterCommerce)
Swansea, Illinois, USA
Eugene.Kelley_AT_networksolutions_DOT_com

• Next in forum: Multidimensional associated array
• Prev in forum: Re: changing indentation with DOMDocument
• Thread view: Re: Search DB by more than one word

[Reply to this message]