Re: [PHP] Mysql search query ignoring dots

2011-01-24 Thread Tom Rogers
Hi, Monday, January 24, 2011, 10:50:41 PM, you wrote: BP> Hi all, BP> I have to perform a mysql query in a table with millions of records. BP> I've full-text indexed my search field and I'm searching with MATCH AGAINST. BP> But there is a problem. In this field there are company names that BP> c

RE: [PHP] Mysql search query ignoring dots

2011-01-24 Thread Tommy Pham
> -Original Message- > From: Barbara Picci [mailto:barbara.pi...@sardi.it] > Sent: Monday, January 24, 2011 4:51 AM > To: php-general@lists.php.net > Subject: [PHP] Mysql search query ignoring dots > > Hi all, > > I have to perform a mysql query in a table with millions of records. > I've

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread tedd
At 2:12 PM +0300 6/4/10, Tanel Tammik wrote: Hello, if there is some webpage content with html tags in database is it possible to search it without tags? data : 'you need some styling!' when i now search for 'you style' i don't want to get any rows! is it possible? when i search 'you styling'

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Ashley Sheridan
On Fri, 2010-06-04 at 15:00 +0300, Tanel Tammik wrote: > "Ashley Sheridan" wrote in message > news:1275652880.2217.54.ca...@localhost... > > On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote: > > > >> "Ashley Sheridan" wrote in message > >> news:1275652342.2217.51.ca...@localhost... > >> >

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Tanel Tammik
"Ashley Sheridan" wrote in message news:1275652880.2217.54.ca...@localhost... > On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote: > >> "Ashley Sheridan" wrote in message >> news:1275652342.2217.51.ca...@localhost... >> > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote: >> > >> >> "As

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Ashley Sheridan
On Fri, 2010-06-04 at 14:54 +0300, Tanel Tammik wrote: > "Ashley Sheridan" wrote in message > news:1275652342.2217.51.ca...@localhost... > > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote: > > > >> "Ashley Sheridan" wrote in message > >> news:1275651371.2217.46.ca...@localhost... > >> >

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Tanel Tammik
"Ashley Sheridan" wrote in message news:1275652342.2217.51.ca...@localhost... > On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote: > >> "Ashley Sheridan" wrote in message >> news:1275651371.2217.46.ca...@localhost... >> > On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote: >> > >> >> Hel

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Ashley Sheridan
On Fri, 2010-06-04 at 14:44 +0300, Tanel Tammik wrote: > "Ashley Sheridan" wrote in message > news:1275651371.2217.46.ca...@localhost... > > On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote: > > > >> Hello, > >> > >> if there is some webpage content with html tags in database is it > >> po

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Tanel Tammik
"Ashley Sheridan" wrote in message news:1275651371.2217.46.ca...@localhost... > On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote: > >> Hello, >> >> if there is some webpage content with html tags in database is it >> possible >> to search it without tags? >> >> data : 'you need some stylin

Re: [PHP] Mysql search html tags excluded

2010-06-04 Thread Ashley Sheridan
On Fri, 2010-06-04 at 14:12 +0300, Tanel Tammik wrote: > Hello, > > if there is some webpage content with html tags in database is it possible > to search it without tags? > > data : 'you need some styling!' > > when i now search for 'you style' i don't want to get any rows! is it > possible?

Re: [PHP] Mysql search

2008-10-23 Thread tedd
At 11:16 PM -0700 10/21/08, Ryan S wrote: Am hoping someone out there can recommend a better script or maybe share some of your own code? Any help would be appreciated. Do it right... read up on MySQL's fulltext matching. Cheers, Rob. Did some searching based on your tip, got what i w

Re: [PHP] Mysql search

2008-10-21 Thread Ryan S
> Am hoping someone out there can recommend a better script or maybe share some > of your own code? > > Any help would be appreciated. Do it right... read up on MySQL's fulltext matching. Cheers, Rob. Did some searching based on your tip, got what i was looking for, just didnt know wher

Re: [PHP] Mysql search

2008-10-21 Thread Robert Cummings
On Tue, 2008-10-21 at 21:48 -0700, Ryan S wrote: > Hey all, > I have two columns in my DB > title varchar(254) > and > jtext text > > which I would like to search, as the user might enter two or more words I am > opting not to use LIKE %search_term% so started searching google, I came > acros

[PHP] Re: PHP/MySQL Search Engine Query Question

2002-07-29 Thread Richard Lynch
>I am currently working on a website that is implemented using PHP and MySQL. > >The site currently has a simple search engine that allows a shopper to type >in a search string that is stored in $search. For example, if a shopper >types in 1972 Ford Mustang >$string ="1972 Ford Mustang" > >Using t

[PHP] Re: php/mysql search. need help

2001-09-08 Thread Richard Lynch
There are various "sounds like" modules such as soundex and metaphone and suchlike. These can ameliorate bad spelling. Another option, if you have a limited number of types available, is to give the user a popup menu rather than free-form box to type in. In general, the fewer ways you can provide