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
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
>
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
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
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
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
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]>,
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
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
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
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
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
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
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
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
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
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
