o find Former Clients who have not been seen after the date
range - Lapsed Client Report
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
;,"Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION study like this?
Thanks in advance for any assistance
Don
;,"Exc","E","S”),
tr.Score DESC
WHEN tr.Placed != "X" THEN tr.ride_time ASC
END
How does one deal with CONDITION study like this?
Thanks in advance for any assistance
Don
cl_date, "%M %Y") AS mo_label FROM
tl_items_classes ic
LEFT JOIN tl_items i ON ic.item_id = i.item_id
WHERE i.active = 1 AND ic.cl_cancelled IS NULL ORDER BY ic.cl_date ASC;
Any help would be appreciated.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
art) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don Wieland
D W D a t a C o n c e p t s
~~
_id
GROUP BY a.client_id
HAVING max(a.time_start) >= UNIX_TIMESTAMP(DATE_SUB( NOW(), INTERVAL 24 MONTH))
AND last_appt IS NOT NULL AND count(a.client_id) >= 2;
BUT, how do I add the other “condition b” to the query to get an accurate end
result.
I’d appreciate any help.
Don
tried that - actually the SUM I need is on the JOIN relationship -
results should be:
1,Banana,3
2,Orange,5
3,Melon,6
Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
invoice_InvoiceLines i ON p.pk_ProductID = i.fk_ProductID AND
i.fk_InvoiceID IN (1,2,3)
WHERE p.pk_ProductID IN (1,2,3)
GROUP BY i.fk_ProductID;
but it is not working.
Little help please. Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
ransaction_id
WHERE ht.donor_id = 730 AND ht.tr_date BETWEEN "2015-01-01 00:00:00" AND
"2015-12-31 23:59:59"
GROUP BY ht.`transaction_id`
ORDER BY ht.tr_date DESC, ht.rec_code ASC;
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
showing one row of the “hiv_transactions” table when there are
multiple rows.
On the GROUP_CONCAT I am trying to get a comma delineated list of the child
rec_code with no duplicates
Appreciate any help. Hopefully a small mod ;-)
Don Wieland
D W D a t a
Hey gang,
I need a few hours of support from a LAMP developer to resolve a few issues via
TeamViewer or GoToMeeting. Anyone who is interested, has the skills, and can
offer this to me, please contact me PRIVATELY. Please include your support
hourly rate.
Thanks!
Don Wieland
d
TERMINATED BY ','
ENCLOSED BY '']
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
asap.
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
'
Do I need to perform this query in a different place? Sigh…
Don
On Sep 19, 2014, at 8:03 AM, Reindl Harald wrote:
into outfile is *not* a db-specific permission
http://lmgtfy.com/?q=mysql+permissions+into+outfile
http://stackoverflow.com/questions/6091427/mysql-into-outfile-access-denied
!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
);
END IF;
INSERT INTO content_asset_statistics (content_asset_id,
statistic_type_code, seq) SELECT NEW.id, statistic_type_code, seq from
content_asset_statistic_types where content_asset_type_code =
NEW.content_asset_type_code;
END;
Appreciate it.
Don Wieland
--
MySQL
= (a := a + 1)
WHERE
document_category = category
ORDER BY
sort_id;
END
//
Don Wieland
d...@pointmade.net
http://www.pointmade.net
https://www.facebook.com/pointmade.band
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
contact me, privately, if you can assist. I am located in California,
USA (PST). Thanks!
Don Wieland
d...@pointmade.net
http://www.pointmade.net
for the work they do on the site ;-)
If you are interested, please contact me PRIVATELY and include a few
examples of your work (websites,etc...). Thanks.
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
on how many emails my server can send per hour.
They recommended I find a 3rd party service provider with support PHP
API connections.
My budget is limited. Does anyone have any suggestions of companies
that might work for my scenario?
Any feedback is appreciated ;-)
Don
--
MySQL General
be earlier
than the start of the date range.
If they have a count of ZERO appts prior to the earliest appt within
the date range, the are a NEW CLIENT else a FORMER CLIENT.
Any assistance would be appreciated. Thanks!
Don Wieland
--
MySQL General Mailing List
For list archives: http
'1321903800'
--- end query 4 ---
Don Wieland
D W D a t a C o n c e p t s
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
AND appt_status_id = '3' AND FROM_UNIXTIME(time_start,'%Y-%m-%d')
between '2012-01-01' and '2012-05-20';
dr_all_ther_qty = 8
I appreciate any enlightenment on this. Thanks!
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
tl_appt table) LESS THAN the stime 0
I am sure I need a multiple select query, but I am having a hard time
wrapping my head around it.
Thanks for any feedback.
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
will be exported or printed? Graphs would be nice, too.
I know I can build this from scratch, but would rather get a hold of
something already pre-built (open source or shareware) to save me a
bunch of coding time.
I appreciate any feedback you can offer!
Don
IN ((select group_concat(payment_id) from
tl_trans_pmt_items where inv_id = 1033911)) AND client_id != 251719
I do not get the same results. Am I missing something? Hopefully
something simple ;-)
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
) as d,
regardless of the combination I use, invalid relationships come back
as NULL - need to return 0 so I can use it in a math formula.
Probably simple - maybe ;-)
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql
Raj Shekhar writes:
One option here might be to use mysql proxy as a man-in-the-middle and
filter out unwanted queries...
This seems more or less the same as what I'm doing now with php.
The same question applies there - what would you look for in your
filter?
--
MySQL General Mailing List
This seems like a topic that must have been studied, but I'm having
trouble figuring out what to search for in Google, since the usual
discussion of sql injection is not what I'm looking for here.
If anyone knows of references that discuss the issue, I'd like to
see them. I'm also interested in
Adam Alkins writes:
Sounds like you just want to GRANT access to specific tables (and with
limited commands), which is exactly what MySQL's privilege system does.
How about this part?
Finally, suppose I want to limit access to the table to the rows
where col1=value1. If I just add that
Daevid Vincent writes:
For the love of God and all that is holy,
do NOT put the user/pass on the URL like that!!
What's so unholy (or even unwise) about it?
Or use mod_auth_mysql to maintain your 'authorized' users to your page.
Why is this so much better?
In my case it's worse cause
Daevid Vincent writes:
For the love of God and all that is holy,
do NOT put the user/pass on the URL like that!!
What's so unholy (or even unwise) about it?
Oh my goodness, where to begin...
Well barring the fact that it'll be in the user's cache and browser
It won't because
/tmp/db.sql
...
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
,
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe
', 'scan', 'done') not null default 'new';
When proc two runs, it should
UPDATE noticed='scan' WHERE noticed='new'
Then repeat the scan with SELECT ... WHERE noticed='scan'
...
and finally it should UPDATE domain=whatever, ... noticed='done'
Regards,
--
Don Read
On Sat, 26 Dec 2009 10:43:55 +0800 Eva said:
2009-12-26 2:36, Don Read :
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
UPDATE noticed='scan' WHERE noticed='new'
Then repeat the scan with SELECT ... WHERE noticed='scan
know or haven't yet found the proper translation
for a phrase it will default to the english language.
* Note the locale field is varchar(5).
There is a de, a de_DE, and a de_CH locale!
Have fun!
--
Don Readdon_r...@att.net
It's always darkest before
SET seen='GOT' WHERE seen='GET';
lather, rinse, repeat.
--
Don Readdon_r...@att.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list
is that the query runs faster the second time around but i dont
have ...
snipage
--
A: It reverses the normal flow of conversation.
Q: What's wrong with top-posting?
A: Top-posting.
Q: What's the biggest scourge on plain text email discussions?
Anybody else see the irony here?
--
Don
invented the
things we are talking about
(http://en.wikipedia.org/wiki/Edgar_F._Codd)
Cheers
Claudio Nanni
And Claudio for the WIN!
--
Don Read donr...@sbcglobal.net
It's always darkest before the dawn. So if you are going to
steal the neighbor's
:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 11:38 AM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mysql Hogging all system resources
On Apr 12, 2007, at 1:17 PM, Don O'Neil wrote:
[ ... ]
Is there a way to prioritize or set the amount of resources that MySQL
is allowed
Nevermind on the badly formatted number... I specified the full path
/usr/bin/nice and it worked ok this time :-)
However, I still want to know if there is a way to specify a nice level for
an entire users processes.
Thanks!
-Original Message-
From: Don O'Neil [mailto:[EMAIL PROTECTED
his processes (old and new) with a nice of 0.
Is there something else I'm missing?
-Original Message-
From: Dan Nelson [mailto:[EMAIL PROTECTED]
Sent: Friday, April 13, 2007 2:57 PM
To: Don O'Neil
Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: Re: Mysql Hogging all system resources
I have a customer that loaded up a HUGE table and was doing all sorts of
fancy stuff in it, and not waiting for the process to finish before sending
the same query, and eventually loading up the server to the point where the
only thing I could do was unplug it.
Is there a way to prioritize or set
This is using version: 5.0.18-log on linux.
I have a stored procedure that takes .2 sec the first time,
12 the second, 12 the third. The data is unchanged.
The relevant part of the procedure looks like this.
...
drop temporary table if exists temptab;
create temporary table temptab (index
Why does this query return no results:
SELECT * FROM FileList WHERE MATCH Filename AGAINST (9640)
When there are entries in the Filename list that have 9640 in them?
I'm using MySQL 5.1.11.
Thanks!
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Yes, there is a full text index, there are about 12,000 rows or so.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday, October 19, 2006 11:47 PM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: Problem with query on 5.11
Don O'Neil wrote:
Why does
I just deleted and re-created my indexes and the query works now... I guess
the index got corrupted somehow. Strange that I never saw any indications of
this in messages, just that 0 rows were returned.
Don
-Original Message-
From: Chris [mailto:[EMAIL PROTECTED]
Sent: Thursday
insert into our tables. Works like a champ.
Don
-Original Message-
From: axis [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 12, 2006 9:10 PM
To: [EMAIL PROTECTED]
Cc: mysql@lists.mysql.com
Subject: What's the best way to INSERT a long list of email addresses and
names into a TABLE
with '../../Customer_Data.csv'?
Axis
On 9/12/2006 10:22:01 PM, Don ([EMAIL PROTECTED]) wrote:
Presuming your csv is set up in the structure of your table - this may
help
BULK INSERT tablename
FROM 'C:\filelocation\my_data.csv'
WITH
(
FIELDTERMINATOR =',',
ROWTERMINATOR
you have to copy support-files/mysql.server
to the right place for your system
PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
To do so, start the server, then issue the following commands:
/usr/bin/mysqladmin -u root password 'new-password'
/usr/bin/mysqladmin -u root -h don
($qry, 'area', $area);
if (! empty($interest))
$qry = andclause($qry, 'interest', $interest);
echo 'span class=ddt', $qry, '/span';
$res = SQLQuery($qry);
...
Have fun.
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you
Where are the client libraries and such for the FreeBSD 4.x Build of MySQL
4.1.18? I downloaded the MAX binary yesterday, and tried to install it, but
none of the libmysqlclient files are present in the distribution.
Do I need to download the sources and build it, or are the client files
located
Yeah, I know about that... But the 4.1.18 client/server isn't there.. Only
4.0.7 or some such older version.
Thanks!
-Original Message-
From: Julian C. Dunn [mailto:[EMAIL PROTECTED]
Sent: Thursday, February 23, 2006 9:39 AM
To: Don O'Neil
Cc: mysql@lists.mysql.com
Subject: Re: MySQL
Hi all...
I have some OLD programs I don't have the source for that were built with
the MySQL 3.23.55 client libraries. They still work great, even when using
those libraries to connect to 4.1.18 Mysql (I have a copy of the old lib in
the new lib dir)
However, is there some way I can build a
, there don't seem to be any symbols in
the executable:
# nm -n /usr/sbin/mysqld
nm: /usr/sbin/mysqld: no symbols
Nor is there a file anywhere on the system named mysqld.sym.gz.
--
Don Doumakes
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
I'm installing MySQL 4.1.14 on a new Gentoo box. When I try to connect
to the mysqld daemon, it crashes and restarts itself, which just doesn't
seem right. I enter these commands:
cd /usr; /usr/bin/mysqld_safe
mysqladmin -u root password 'foobar'
and get this response:
mysqladmin: connect
the reading - but my Google search seems to turn up more info
about multi-table deletes than inserts. I realize that MySQL doesn't
support a single multi-table insert function, but are the two approaches I
see good, bad, common??
Thanks,
Don
--
evangelinuxGNU Evangelist
http://matheteuo.org
for a partial entry. For
example. If I have an entry where Booking is 'TSIN15' and I search on
the string 'TSIN15', it is found.
How can I get it to find a partial match if the string I enter is only
'15' ?
Thanks,
Don
--
MySQL General Mailing List
For list archives: http
with a '12345' in it.
Hence, partial matches
Thanks,
Don
-Original Message-
From: Gordon Bruce [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:31 PM
To: Don; mysql@lists.mysql.com
Subject: RE: Are partial searches possible?
You can try
if($queryID = mysql_query(SELECT
Maybe a good question to ask is where can I find documentation on:
MySQL WHERE where_definition
Specifically, all the options available for the 'where_definition'
-Original Message-
From: Don [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 08, 2005 3:40 PM
To: mysql@lists.mysql.com
releases...
Don
smime.p7s
Description: S/MIME Cryptographic Signature
as they did in prior releases...
Don
smime.p7s
Description: S/MIME Cryptographic Signature
] Fatal error: Can't open privilege tables: Table
'mysql.host' doesn't exist
050423 12:07:20 mysqld ended
--
Don
Vaillancourt
Director of Software Development
WEB
IMPACT INC.
phone: 416-815-2000 ext. 245
fax: 416-815-2001
email: [EMAIL
didn't read all the results of query 2, so they may show up
somewhere I don't want them?
Is there a way to do this, does it work and I am missing something?
Thanks,
Don.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com
this by creating a new select
statement and running it.
It seems this is not possible if the framework tries to use a single
global connection to the daemon, yes? no?
Can another connection be made?
thanks,
Don.
---
[EMAIL PROTECTED] wrote:
The parent-child type of query you want to make
Eric Bergen wrote:
If you can use mysqldump to export the data from 3.23 with the -Q
switch to quote all db, table, and column names.
Thanks for the input, that has worked for me in the past, but it's on a hosted db server and I don't think I have rights to run mysqldump on it. I was hoping to
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near 'wish_list_id`
Don Stefani wrote:
Hello,
I am trying to import a table structure from ver 3.23.52 to ver
4.1.7-max and I am getting an error:
--- error -
|#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
GH wrote:
I am using IIS :(
On Windows... Which do i install first? PHP or MySQL?
Apache. :)
If your just working on a local dev box, it may not be that big of a deal.
PHP using IIS is a bit easier to install than Apache since PHP5 does not
have an installer that auto-configs
())
$rank[$row['user_id']] = $row['rank'];
$dbconn-Execute('UPDATE user SET rank=0');
foreach($rank as $id = $r) {
$qry = UPDATE user SET rank=$r WHERE user_id=$id;
$dbconn-Execute($qry);
}
}
Regards,
--
Don Read
root flush-privileges password newpwd
I get the error:
mysqladmin: unable to change password; error: 'Can't find any matching row
in the user table'
I think my user table is screwed up but how can I get in to fix it???
Worst case, do I just uninstall and reinstall mysql?
Thanks,
Don
as per the instructions
that came with it, and i can't get the test light to come on at all which says
something, I think.
Any help appreciated.
Thanks,
Don
,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
.
hittime DATETIME NOT NULL DEFAULT '-00-00',
prd MEDIUMINT UNSIGNED NOT NULL DEFAULT 0,
...
KEY idx_p (prd),
...
UPDATE tbl SET prd=EXTRACT(YEAR_MONTH FROM hittime) ...
Then query it with
SELECT ... WHERE prd=200408 etc.
--
Don Read [EMAIL
.
These are the stock compiled .tar.gz distributions.
My service seems to still run fine, and it's not reporting not being
able to connect. Multiple hosts get the error, not just one IP.
Any ideas?
Thanks,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http
How do I turn on the General log file in version 3.23.52? Can I put an entry in the
my.cnf file and reboot?
Thanks,
Don
to a port so I'm
figuring it's using the default 3306.
I can ping the server.
Any ideas?
Thanks,
Don
error near .. very useful or am I giving up to easy?
Howzabout :
mysql_query($qry) or
die(sprintf('pBorked query at file %s line %d :br /%s',
__FILE__, __LINE__, nl2br($qry)) .'br /'
.mysql_errno() .'br /' .mysql_error());
--
Don Read [EMAIL
mediumint(6) unsigned zerofill NOT NULL auto_increment,
idcust mediumint(5) unsigned zerofill NOT NULL,
...
);
You can make some pretty decent reports with a shell script if the DB
lends a hand with formatting.
--
Don Read [EMAIL PROTECTED]
-- It's
Is it possible to do something like this?
If(select * from xxx, if record found..update it, if record not found ..insert it)
Thanks,
Don
A;
This return's up to ten characters after the name, somethimes this is
to
much, sometimes to many. Does anybody knows how to go from here.
LEFT(SUBSTRING_INDEX(foo, ';', 1), 10)
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So
is the leader in supporting Access Control Lists...is that a
consideration for a MySQL server?
Thanks,
Don
I ran ./bin/safe_mysqld
and got:
[1] 3328
root # Starting mysqld daemon with databases from /usr/local/mysql/data
and the cursor hangs on the next line down ...
thanks,
don
Try ls to see whether safe_mysqld is in the directory and the run:
Safe_mysqld
Note! You have to be root
Ok, that worked. Thanks.
I guess now my only question is is there something wrong with my environment since I
have to type:
./bin/mysql -u root
instead of
mysql -u root?
Thanks,
Don
At 9:30 -0700 4/16/04, Don Dachner wrote:
I ran ./bin/safe_mysqld
and got:
[1] 3328
root
work fine, but INSERT hangs.
Thanks,
Don
Jaroslav Kocourek wrote:
FWIW, I'm still having this problem.
I've completely dropped the table and re-built it from the ground up.
It's a bizarre problem... The table is totally simple. A primary key,
and then three varchar fields. The FULLTEXT
Thanks for the help! Worked perfectly.
Don
Paul DuBois [EMAIL PROTECTED] wrote:
At 10:01 -0700 4/16/04, Don Dachner wrote:
Ok, that worked. Thanks.
I guess now my only question is is there something wrong with my
environment since I have to type:
./bin/mysql -u root
instead of
mysql -u
Success with the bug entry. Nice system, too.
http://bugs.mysql.com/bug.php?id=3483
Thanks,
Don
Don MacAskill wrote:
This problem is completely repeatable, I'm not the only one having it,
and I've found a (temporary) workaround. I'm not sure if it affects
other machines than AMD64
if not all of those
files.
Don
and run the query:
UPDATE tbl SET ts= DATE_SUB(ts, INTERVAL 10 HOUR) WHERE ...
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General
pretty tiny.
A mysqldump of the table is only 442K.
Has no-one else seen anything like this? I can't imagine I'm the only one.
Thanks,
Don
Don MacAskill wrote:
Hi there,
I've got a bizarre problem I can't seem to solve. I have a small MyISAM
table (6533 rows) with a small FULLTEXT index
This should be simple, no? I can't make it work
Objective:
- bring up a panel to ask for MySQL User/Host/Password and save settings if
we get logged in.
- when we start (likely on a new machine) create a new Weather DB if it
doesn't exist
- when we start ( ) create a new TimeTable table if
. Any help would be greatly appreciated!
Thanks,
Don
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
(membershiptype + 1, '2', '0', '1') ASC
-- or --
MAKE_SET(membershiptype, 'a','b') DESC
Regards
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL
On 25-Mar-2004 [EMAIL PROTECTED] wrote:
Not using perl or php I came up with:
mysqlshow -u user --status db_name | awk -F| '{print $2,$5}' | grep
-i pattern
Is there a query to do the same thing?
SHOW TABLE STATUS
--
Don Read [EMAIL PROTECTED
W [EMAIL PROTECTED]
To: Don Dikunetsis [EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: Re: fulltext search always returns no results
Date: Thu, 26 Feb 2004 01:26:17 -0600
Hi Don,
No, full-text search was added in MySQL 3.23.23, I believe (4.0.1 just
added boolean searches along with more speed
Lovatt [EMAIL PROTECTED]
To: Matt W [EMAIL PROTECTED], Don Dikunetsis
[EMAIL PROTECTED], [EMAIL PROTECTED]
Subject: RE: fulltext search always returns no results
Date: Thu, 26 Feb 2004 07:57:21 -
Hi
Full text can have some strange results.
It ignores common words, like the, if, and, etc
Summary: When I run a fulltext search, it always returns no results. I have
added a fulltext index to the column being searched. Also, I am searching
for a term that is in the table, but not in more than 50% of the rows.
I notice that when I add EXPLAIN to my search, the key_len of my fulltext
Hi, thanks for your reply, but it looks like:
As of Version 3.23.23, MySQL has support for full-text indexing and
searching.
--according to:
http://www.mysql.com/doc/en/Fulltext_Search.html
However, I would be unsurprised (though disappointed) to find that the
answer is some variant of this
TEMPORARY TABLE
Regards,
--
Don Read [EMAIL PROTECTED]
-- It's always darkest before the dawn. So if you are going to
steal the neighbor's newspaper, that's the time to do it.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
1 - 100 of 427 matches
Mail list logo