On Tue, 2 Nov 2004 21:57:36 -0500, [EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > 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: > http://lists.mysql.com/[EMAIL PROTECTED] > > > > > > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]