Re: Fulltext Relevancy not returning anticipated results?

Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Mike Morton [mailto:[EMAIL PROTECTED] Sent: Monday, October 29, 2007 5:39 PM To: mysql@lists.mysql.com Subject: Fulltext Relevancy

Re: Fulltext Relevancy not returning anticipated results?

. Regards, Jerry Schwartz The Infoshop by Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 www.the-infoshop.com www.giiexpress.com www.etudes-marche.com -Original Message- From: Mike Morton [mailto:[EMAIL PROTECTED

Re: Fulltext Relevancy not returning anticipated results?

for the starting point for finding that mistake Baron! :) *knocks head against wall repeatedly* On 10/30/07 5:09 PM, Baron Schwartz [EMAIL PROTECTED] wrote: Mike, Mike Morton wrote: OK - I am at a total loss here :) We have added an addition fulltext field with the highest rating: match

Fulltext Relevancy not returning anticipated results?

on this? The term vic used in this case is the search string submitted by the user. You can see the search in action at http://www.tienda.com/support/search.html -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED

Sorting by a list of possible results in a column....

, but that is (in my opinion) an unnecessary step that could be handled at the database query Thanks! Sample query: Select * from development order by status -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED

Table definitions not accepting data as defined...

, `english` text, `spanish` text, `active` char(1) default 'n', PRIMARY KEY (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=7096 ; -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED

Fulltext relevance and weighting....

PHP) TIA - hope someone can help! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Fulltext relevance and weighting....

to change the minimum word length. See http://dev.mysql.com/doc/refman/5.0/en/fulltext-fine-tuning.html Mike (P.S. Send me a free ham while you're at it.g) At 02:02 PM 1/31/2007, Mike Morton wrote: Does anyone have any suggestions on how to solve the result weighting problem? I have a client

Sum problem....

... Any suggestions? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe the history of the computer industry

If statement in a where query....

this logic using an if statement in the where statement? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe

Mysql command line queries not working....

without comments, as removing them every time there is a new dump will be tedious to say the least... 3. Am I a total idiot and have missed something dead simple? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED

Re: Mysql command line queries not working....

Message- From: Mike Morton To: [EMAIL PROTECTED] Sent: 8/26/04 12:05 PM Subject: Mysql command line queries not working I know the subject is not totally descriptive of the problem, but: mysql -h -u *** -p*** mikerocks latest_distribution.sql Is producing no results

Group by for datetime

) Or something along those lines? Tia! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe the history of the computer

Sleeping Processes

suggestions or ideas I would appreciate it as I am plumb out of them! :) TIA -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration

Re: Sleeping Processes

be skipped... My $0.02... Dan Greene -Original Message- From: Mike Morton [mailto:[EMAIL PROTECTED] Sent: Tuesday, January 06, 2004 2:15 PM To: [EMAIL PROTECTED] Subject: Sleeping Processes I have a mysql database that is running in conjunction with a PHP website

Database field length standards

Is anyone aware of international standards for field lengths for commonly used database fields? I.e Firstname Lastname Address City State Etc The basic contact information for a user...? If anyone knows of a standard, please email me a link or reference to it. Thanks :) -- Cheers Mike

Limitations on data for default...

Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe the history of the computer industry for the past decade as a massive effort

Re: Limitations on data for default...

much precision since you only wanted the date, not the time. http://www.mysql.com/doc/en/DATETIME.html Mike On Thursday 13 November 2003 16.15, Mike Morton wrote: I am trying to change a column specification, a date column, so that the default value is the current date. Is this possible

Re: web hosting/PHP MyAdmin

. best, Matthew Gold -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe the history of the computer industry

Re: Query not returning 0 count records....

' AND '2003-09-31' GROUP BY afs.stat_date Hope that helps. Matt - Original Message - From: Mike Morton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 6:27 PM Subject: Query not returning 0 count records In the following query: select

Re: Query not returning 0 count records....

' AND '2003-09-31' GROUP BY afs.stat_date Hope that helps. Matt - Original Message - From: Mike Morton [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 02, 2003 6:27 PM Subject: Query not returning 0 count records In the following query: select

Query not returning 0 count records....

Is it possible to return results like this, and if so, what is wrong with my query? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would

Too many hours - brain not working.....

to do it in one query. If this is possible to do - how? TIA! -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe

Re: Too many hours - brain not working.....

Thanks to everyone that replied on and off list - off to the group by docs ;) On 8/28/03 5:09 PM, William R. Mussatto [EMAIL PROTECTED] wrote: Mike Morton said: Hey y'all - I have been at this too long today - this is driving me nuts! Table: Date (y-m-d),amount (decimal),dealercode I

Multi-table query in one select - possible?

without doing all sorts of other connections. As you can see I am using MYSQL 3 - so no union queries - and I cannot upgrade the database since it is on a host provider. Any assistance is appreciated! TIA -- Cheers Mike Morton * * Tel: 905

Re: Help me pls

Jun 2003 18:02:23 + To: [EMAIL PROTECTED] From: Syamsul Arifien Subject: Help me pls Hi ... I hv problem... I can't conec to my MysqlSvr with mysql_connect() in my php script.. anybody knows? best regard Syamsul Arifien -- Cheers Mike Morton

Multi-table count

in the right direction? TIA -- Cheers Mike Morton * * Tel: 905-465-1263 * Email: [EMAIL PROTECTED] * Indeed, it would not be an exaggeration to describe the history of the computer industry

Re: Multi-table count

to do it in (B one (B (B Is it possible to do what I am asking? If so could someone point me in the (B right direction? (B (B TIA (B (B (B -- (B Cheers (B (B Mike Morton (B (B (B * (B * Tel: 905-465-1263 (B * Email: [EMAIL