On Tue, 2 Nov 2004 21:57:36 -0500, cjnoyes@stripped said:
> From my understanding of how text indexing is done, & and other
> don't get indexed. What happens is the actual word content is broken
> 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
> 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 & When I select the field via sql I also see
> > 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&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: