- I'm not a pro in MySQL, so if I explained
something
wrong, I hope the more experienced members will correct it.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 8 Oct 2004 at 16:30, Ed Lazor wrote:
> Hi Everyone,
>
> I got excited when I discove
erform
the search. It is important that you do NOT OMIT the ' '.
TIP. You should be able to perform this search on various columns at the same time, as
long as they belong to the SAME TABLE. This way, searching title, description, etc.
Again,
take a look at the MySQL Manual.
Remi
This should work. No sub-selects needed here.
select a.people_name, b.people_name as people_friend_name
from people a, people b
where a.people_friend_ID=b.people_ID
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 7 Oct 2004 at 10:34, Ronan Lucio wrote:
>
if a word
appears
many times in a certain text, etc.) I'm not sure if I can help you.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 5 Oct 2004 at 12:42, Ed Lazor wrote:
> > -Original Message-
> > Try this:
> >
> > selec
vance
value in
the result if you want to.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 5 Oct 2004 at 10:53, Ed Lazor wrote:
> Is there a way to have boolean fulltext searches and still have results
> automatically sorted in order of decreasing relevance
Ok. Thank you for all your help! I will perform some tests to see how to get the best
results.
Thank you for offering to help with this stage, but I'll try doing it by myself.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 5 Oct 2004 at 14:11, [EMAIL PROT
pared to the first option, and as long as it is faster than my current solution, I
would
prefer it.
Thanks a lot for all these pointers!
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 5 Oct 2004 at 9:45, [EMAIL PROTECTED] wrote:
> You are correct, there is no pre
my hosting company would change the GROUP
BY behaviour for all clients on my server because of me.
If I missed the whole point of the suggestion... please let me know!
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
On 5 Oct 2004 at 9:07, Paul DuBois wrote:
> At
d not critical at all if it happens once in a million) I might not get the correct
result anyway.
Maybe I'm being picky, but while I'm at it it might as well get well done.
Thank you for the help so far anyway!!
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iM
ave 10 unique users
in the
table, even with 1.000.000.000 records! I just never know. I also have to make two
queries,
which gives a small overhead. Finally, using scripting to interprete intermediate
results is
much slower than MySQL. All in all, this just doesn't seem to be a very scaleable
so
lf very well, but if anyone is willing to
help, I
would of course clarify things if necessary.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mance, or is the only solution to execute two queries?
Remodeling the database is not possible in my case. The fulltext search is a small
part
of a new search engine for a database that has been on-line for over a year now.
Remi Mikalsen
E-Mail: [EMAIL PROTECTED]
URL:http://www.iMikalsen.com
-
SELECT B.ID
FROM Characteristic AS B
WHERE B.ID IN('X','Y','Z')
MINUS
SELECT C.IDCharac
FROM CarCharacteristics AS C
WHERE C.IDCar=A.ID
) IS NULL
);
I appreciate any help
Working solution Bruce Feist
SELECT Films.idFilm, title
FROM Films LEFT JOIN Loans
ON (Films.idFilm = Loans.idFilm) AND (Loans.return_date IS NULL)
WHERE Loans.idFilm IS NULL;
Note: This solution works for me as it considers that I give no value (NULL) to
the attribute return_date at th
Hello,
I believe, and hope, I have a very simple question, but as I am relatively new to
MySQL I might be missing out on the obvious solution.
Is it possible to use a single MySQL query (with the simple scheme presented) to
ask the following question?
Scheme:
Films (idFilm, title)
Loans (i
15 matches
Mail list logo
