List:General Discussion« Previous MessageNext Message »
From:leegold Date:November 3 2004 3:05am
Subject:Re: ampersands in the database fields
View as plain text  
On Tue, 2 Nov 2004 21:57:36 -0500, cjnoyes@stripped said:
> From my understanding of how text indexing is done, & and other
> punctuation
> don't get indexed. What happens is the actual word content is broken
> appart
> and indexed on a word by word basis on your NA & SD it would be broken up
> into two terms and NA and SD would be indexed. 

That explains why Fulltext will not find it, it won't find 3 or loss
char words by default.

> I don't know if. What tool
> are you querying with that brings up the & is it PhpMyAdmin? 

No I'm using SELECT from the command line.  "&"  is what's actually
in the DB field. Should I UNencode & to give  just  "&"  before
before I insert?:P

Thanks


> a web interface may cause problems try to go into the plain command line mysql
> client and see what comes up on a query
> Christopher J. Noyes
> ----- Original Message -----
> From: "leegold" <leegold@stripped>
> To: <mysql@stripped>
> Sent: Tuesday, November 02, 2004 9:14 PM
> Subject: ampersands in the database fields
> 
> 
> > The subject title is a sedgeway into my question that may slightly of
> > topic but I've asked many sources and don't have an answer yet so I ask
> > it here.
> >
> > I have a text fields of html marked up content which I render via php.
> > Looking at the rendered html page in a text editor I see that ampersands
> > all appear as   &amp;   When I select the field via sql I also see
> &amp;
> >
> > I have a pretty standard seach, Fulltext and substring (ie. %keyword%)
> > searches. There's an acronym in my content:   NA&SD    and when I try
> > searching for this it really mucks up. The Fulltext no matter what I try
> > does not get a hit. The substring search will work properly if I put the
> > following in the search form:    NA&amp;SD    that works.  But trying
> > the substring search with   NA&SD   produces weird results...kinda works
> > but strangely and affects the rendering of the search results page.
> >
> > So what's the cause of all this? Should I upfront load my db text fields
> > differently, or, search them differently - what is the  fix  via mysql
> > or php for the ampersand problem?
> >
> > Thanks,
> > Lee G.
> > Washington DC
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
> >
> >
> >
> >
> 
Thread
mysql admin clientsleegold1 Nov
  • Re: mysql admin clientsGleb Paharenko2 Nov
  • Re: mysql admin clientsMartijn Tonies2 Nov
  • Re: mysql admin clientsAndy Davidson2 Nov
    • ampersands in the database fieldsleegold3 Nov
      • Re: ampersands in the database fields-{ Rene Brehmer }-3 Nov
  • Re: mysql admin clientsKaram Chand6 Nov
Re: ampersands in the database fieldsleegold3 Nov