Re: [PHP] FULLTEXT: It worked?? Why?
On Monday 25 November 2002 13:33, John Taylor-Johnston wrote: > Sorry Jason ... No offense, Don't apologise to me. Apologise to the list members if you have to. > I learned my MySQL here :) Jolly good. > It's for a PHP > script, after all. And what has this got to do with the price of fish? > Besides unless I want to fill my mail box quota in 3 > minutes ... Here I can post using a news-reader. This is absolutely no excuse for OT posting. Get a bigger mailbox if you have to. I'm not trying to be rude -- I just want say: - whatever your reasons are, your post is OT - if you have to post a db related question to a php related list then use php-db (as opposed to php-general) - the bottom line is if you post to the right place you'll get a better answer (I would like to think that the people on the MySQL list knows MySQL better than the people on the PHP-General list). -- Jason Wong -> Gremlins Associates -> www.gremlins.biz Open Source Software Systems Integrators * Web Design & Hosting * Internet & Intranet Applications Development * /* knowledge, n.: Things you believe. */ -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] FULLTEXT: It worked?? Why?
Jason,
Sorry Jason ... No offense, I learned my MySQL here :) It's for a PHP script, after
all.
Besides unless I want to fill my mail box quota in 3 minutes ... Here I can post using
a news-reader.
Can anyone out there help :) please?
John
> On Monday 25 November 2002 10:59, John Taylor-Johnston wrote:
> > MySQL4.0.1 Question. HTOK
> >
> > FULLTEXT index confusion.
> >
> > Why does my SQL work?
> >
> > SELECT YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,AUS
> > FROM ccl_main
> > WHERE MATCH (AUS)
> > AGAINST ('+margaret +atwood' IN BOOLEAN MODE)
> > ORDER BY id desc
> >
> >
> > AUS is not part of my FULLTEXT Index. So why does it work? How does
> > FULLTEXT work then???
> >
> > CREATE TABLE ccl_main (
> > id int(10) unsigned NOT NULL auto_increment,
> > ...
> > PRIMARY KEY (id),
> > FULLTEXT KEY CCL2002 (YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC)
> > ) TYPE=MyISAM COMMENT='CCL Bibliography - Bibliographie ECC';
>
> This has nowt to do with PHP, please ask on the MySQL list.
>
> --
> Jason Wong -> Gremlins Associates -> www.gremlins.biz
> Open Source Software Systems Integrators
> * Web Design & Hosting * Internet & Intranet Applications Development *
>
> /*
> Passionate hatred can give meaning and purpose to an empty life.
> -- Eric Hoffer
> */
--
John Taylor-Johnston
-
"If it's not open-source, it's Murphy's Law."
' ' ' Collège de Sherbrooke:
ô¿ô http://www.collegesherbrooke.qc.ca/languesmodernes/
- Université de Sherbrooke:
http://compcanlit.ca/
819-569-2064
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] FULLTEXT: It worked?? Why?
On Monday 25 November 2002 10:59, John Taylor-Johnston wrote:
> MySQL4.0.1 Question. HTOK
>
> FULLTEXT index confusion.
>
> Why does my SQL work?
>
> SELECT YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC,AUS
> FROM ccl_main
> WHERE MATCH (AUS)
> AGAINST ('+margaret +atwood' IN BOOLEAN MODE)
> ORDER BY id desc
>
>
> AUS is not part of my FULLTEXT Index. So why does it work? How does
> FULLTEXT work then???
>
> CREATE TABLE ccl_main (
> id int(10) unsigned NOT NULL auto_increment,
> ...
> PRIMARY KEY (id),
> FULLTEXT KEY CCL2002 (YR,AU,ST,SD,SC,BT,BD,BC,AT,AD,AC)
> ) TYPE=MyISAM COMMENT='CCL Bibliography - Bibliographie ECC';
This has nowt to do with PHP, please ask on the MySQL list.
--
Jason Wong -> Gremlins Associates -> www.gremlins.biz
Open Source Software Systems Integrators
* Web Design & Hosting * Internet & Intranet Applications Development *
/*
Passionate hatred can give meaning and purpose to an empty life.
-- Eric Hoffer
*/
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
