on 5/6/04 16:53, Michael Stassen at [EMAIL PROTECTED] wrote:
> If you've built from source, the stopwords are in
>
> path-to-source/myisam/ft_static.c
>
> In my copy of 4.0.18, beyond is in the list.
>
> You can create your own stopword list, or turn off stopwords altogether, if
> you want. S
Vance Pattishall at [EMAIL PROTECTED] wrote:
> Check to see if beyond is in your stopword file.
>
>> -Original Message-
>> From: Richard Baskett [mailto:[EMAIL PROTECTED]
>> Sent: Thursday, May 06, 2004 2:12 PM
>> To: MySQL
>> Subject: Fulltext searching
>
Ok having some problems with MySQL's fulltext search. I have the fields
that I need fulltext indexed, everything seems to be working correctly, but
for some reason when I search for "beyond" looking for an item called:
"Beyond Heaven yoga & Day Spa"
It doesn¹t find it.. I am searching in boolea
Ok finally found the answer after many hours of searching :) Here is the
MySQL query that works great!
SELECT * FROM table_name
WHERE Email NOT
REGEXP "^[0-9a-z]([-_.]?[0-9a-z])*@[0-9a-z]([-.]?[0-9a-z])*\\.[a-z]{2,3}"
Thanks to all that replied!
Rick
"Keep away from people who belittle your a
I would like to search an email address field for all values that do not
have a '@' in them. How would I go about doing this?
So far this query is what I have:
SELECT * FROM `table_name` WHERE Email REGEXP "^[@]";
But I am doing something wrong, because it's just not working :)
Thanks!
Rick
Is there a way to combine these queries?
SELECT count(SeekID) FROM Seekers
WHERE DateLastLog(NOW()-INTERVAL 7 DAY)
SELECT count(SeekID) FROM Seekers
WHERE DateLastLog(NOW()-INTERVAL 1 MONTH)
Or these?
SELECT count(ResumeID) FROM Resumes WHERE testResume='1'
SELECT count(ResumeID) FROM Resumes
estroy
the genius of youth." - Unknown
> From: "Keith C. Ivey" <[EMAIL PROTECTED]>
>
> On 14 Aug 2002, at 14:46, Richard Baskett wrote:
>
>> Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
>> STRAIGHT_JOIN though (received
mysql to 3.23.51 and the problem was solved.
>
> Richard Baskett wrote:
>
>> Ok Im still having some serious speed problems and obviously since more
>> records are being added every day the problem is getting worse. Here is the
>> query:
>>
>> SELECT DISTI
Ok that saved me 5 seconds per query! So far so good! I couldn¹t use the
STRAIGHT_JOIN though (received errors) so I made it an INNER JOIN. This is
the new query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Location
INNER
Ok Im still having some serious speed problems and obviously since more
records are being added every day the problem is getting worse. Here is the
query:
SELECT DISTINCT Location.SortID AS Loc, LocName, JobTitle AS Job, Company AS
Comp, Jobs.JobID, Employers.EmpID
FROM Employers
INNER JOIN Jobs
ideas would be greatly appreciated!
Cheers!
Rick
"Work like you don't need the money. Dance like no one is watching. And love
like you've never been hurt." - Mark Twain
> From: Richard Baskett <[EMAIL PROTECTED]>
> Date: Wed, 31 Jul 2002 13:41:56 -0700
> To: Da
t;
> Subject: Re: Speed issues...
> From: "Jared Richardson" <[EMAIL PROTECTED]>
> ===
> "Richard Baskett" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]...
>> This is my first post here.. So be nice! ;)
>>
>> I have
and there shall be no
more death, neither sorrow, nor crying, neither shall there be any more
pain: for the former things are passed away." - Revelation 21:4
> From: Dan Nelson <[EMAIL PROTECTED]>
> Date: Wed, 31 Jul 2002 15:09:24 -0500
> To: Richard Baskett <[EMAIL PRO
egory and JobsLocation first when
> they're constrained with LEFT JOIN.
>
> --
> Dan Nelson
> [EMAIL PROTECTED]
>
> From: Dan Nelson <[EMAIL PROTECTED]>
> Date: Wed, 31 Jul 2002 13:42:41 -0500
> To: Richard Baskett <[EMAIL PROTECTED]>
> Cc: Tod Harter <[E
take
them out! yes?
Cheers!
Rick
"When the solution is simple, God is answering." - Albert Einstein
> From: Tod Harter <[EMAIL PROTECTED]>
> Organization: Giant Electronic Brain
> Date: Wed, 31 Jul 2002 09:57:20 -0400
> To: Richard Baskett <[EMAIL PROTECTED]>,
This is my first post here.. So be nice! ;)
I have a database with a little over 60,000 records and when I do a search
on that db it takes a little over a minute and a half to return results.
This is very unacceptable, but Im just not sure what I can do to remedy
this. Here is what the query loo
Kind of hard to say without source code for the session part.. Although the
MySQL warnings, I got those because MySQL does not automatically start in
OSX, if you know it's started then Im not sure, but if not.. go here to get
the autostart utility:
http://www.entropy.ch/software/macosx/mysql/
T
17 matches
Mail list logo
