When I do the following query:
SELECT * FROM geo_trivia WHERE city IS NULL;
certain columns that DO have 'NULL' value for city and not a '' (blank)
value do not show up.
I have even gone to the extent of reseting these records value as ='NULL'
with UPDATE and they are still are not selected
Have you tried to set city = null (i.e. without the quotes)? David.
-Original Message-
From: Richard Reina [mailto:gatorre...@gmail.com]
Sent: Friday, March 09, 2012 4:24 PM
To: mysql@lists.mysql.com
Subject: query problem with null
When I do the following query:
SELECT * FROM
-
From: Richard Reina [mailto:gatorre...@gmail.com]
Sent: Friday, March 09, 2012 4:24 PM
To: mysql@lists.mysql.com
Subject: query problem with null
When I do the following query:
SELECT * FROM geo_trivia WHERE city IS NULL;
certain columns that DO have 'NULL' value for city
- Original Message -
From: David Lerer dle...@us.univision.com
Have you tried to set city = null (i.e. without the quotes)?
Spot on, I'd think.
NULL values are not a string with NULL in it - that's only what it looks like
in query results :-) An empty string ('') is to strings
in my database,
if i want to render firstname and lastname match case ,
am using REGEXP '^[abcd]' WORK FOR SINGLE FIELD,
Now i have fname and lastname ,
How to make the query , which display both and single field satisfieds
records ,
That is my query should return like
Name(combined
Is this what you meant?
SELECT * FROM tbl where Fname REGEXP '^[abcd]' AND Lname REGEXP '^[abcd]'
(alternatively, the extression could be simpliefied as REGEXP '^[a-d] )
- md
On Fri, Oct 22, 2010 at 11:01 AM, bharani kumar
bharanikumariyer...@gmail.com wrote:
in my database,
if i want to
Hi ,
Am just trying alphabetical pagination ,
Yes there is lot of pager class there for this ,
but in my requirement little but diff , that is
totally 4 sets ,
A-DE-H I-PQ-S (Assume there are pager links)
When user click the A-D , then it should show all the customer name
You regular expression is alittle off. You don't need the OR operator
'|' inside the character class definition, it is implied. Try this:
[php]
SELECT * FROM tbl where Fname REGEXP '^[abcd]'
[/php]
- michael dykman
On Thu, Oct 21, 2010 at 11:07 PM, bharani kumar
bharanikumariyer...@gmail.com
So I'm having a problem with an update query. I have three tables:
Table: A
Columns: acnt, name, company, email, domain
Table: AM
Columns: acnt, m_id
Table: M
Columns: m_id, name, company, email, domain
and I want to conditionally update the columns in one to values from the
other.
Try using the IS NULL operator instead of !
-Travis
-Original Message-
From: Andy Wallace [mailto:awall...@ihouseweb.com]
Sent: Thursday, September 16, 2010 10:47 AM
To: mysql@lists.mysql.com
Subject: Update query problem
So I'm having a problem with an update query. I have three
of wat is suppliers which table is it coming from
etc.
-Original Message-
From: Tompkins Neil [mailto:neil.tompk...@googlemail.com]
Sent: Monday, December 22, 2008 5:16 PM
To: Baron Schwartz; [MySQL]
Subject: Re: Distinct Query Problem
Hi,
If anyone could point me in the right
Hi
I'm having trouble trying to figure this out. Any help/example would be
grateful.
Thanks
Neil
On Sun, Dec 21, 2008 at 4:30 PM, Baron Schwartz ba...@xaprb.com wrote:
On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
of products for all suppliers for a
Hi,
If anyone could point me in the right direction, I'd be most grateful.
Thanks !
Neil
On Mon, Dec 22, 2008 at 9:55 AM, Tompkins Neil neil.tompk...@googlemail.com
wrote:
Hi
I'm having trouble trying to figure this out. Any help/example would be
grateful.
Thanks
Neil
On Sun, Dec
OK, I've made further progress by changing GROUP BY ProductTB.ProductID,
MasterTB.MasterID to GROUP BY MasterTB.MasterID.
However ProductTB.Supplier is showing the incorrect Supplier. Why is this ?
Thanks
Neil
On Mon, Dec 22, 2008 at 11:45 AM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
On Fri, Dec 19, 2008 at 1:03 PM, Tompkins Neil
neil.tompk...@googlemail.com wrote:
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
Hi,
I've the following query which I'm having problems with. Basically I have
a 5 tables as follows :
MasterTB - Contains list of master records
LookupTB - Contains relationship between MasterTB to ProductTB
ContentTB - Contains description of product, and location of data files
PriceTB -
On Fri, Dec 19, 2008 at 7:03 PM, Tompkins Neil wrote:
Basically each product is listed in the master table, and can have a number
of suppliers linked to it (ProductTB). The query above will show me a list
of products for all suppliers for a particular product. However I want to
be able to
I am trying to display results from one or the other part of the
query, however, at the moment it is showing results from both parts.
The Replace part of the query works fine in that it chooses the
correct data to display, but the content relevant to /8/ always
displays even when I select,
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
DateTime UserName SiteName
ScanType Status Virus_Category
| 2008-04-16 | 13:05:31 | 172.16.1.22 | - | www.veer.com
|C | A
On Wed, Apr 16, 2008 at 4:35 AM, sivasakthi [EMAIL PROTECTED] wrote:
Hi all,
Iam having the one table name called AccessDetails and data inside that
tables is following,
[snip=schema]
In that , I need to calculate the number of total sites , number of
total Accessed Sites,number of
Hi, I have built a site with Dreamweaver and I have a problem with a
query.
I am trying to pass a parameter from one page to another to drill
down. Basically, I have one product entry that is in multiple
categories on my website. So, say it's a dress, it is therefore
related to category
Dear Mat,
Your mail is not very clear. But I have a feeling that using '%' wildcard in
the like operand should help you
Regards,
Ravi.
On 11/14/07, Matthew Stuart [EMAIL PROTECTED] wrote:
Hi, I have built a site with Dreamweaver and I have a problem with a
query.
I am trying to pass a
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative values; request, which
Ed Reed wrote:
Hi All,
I have an issue that I need to resolve that is difficult to explain. I
hope that someone can understand what I*m trying to do and shed some
light on a solution. Here goes.
I have three tables, inventory, which is a list of transactions with
positive and negative
Thanks Jay,
I had to make a change to the first part of the query to get the results that I
wanted but your suggestion was definitely what I needed to get to the solution.
Thanks again.
For those that are interested, here's the final solution,
INSERT INTO purchase (Source, Item, Qty)
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested queries
but want to try and do it on one line. My current query
$query = SELECT * FROM images, properties WHERE images.property_id =
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested
queries but want to try and do it on one line. My current query
$query = SELECT * FROM images, properties WHERE images.property_id =
On Wed, May 09, 2007 at 07:14:38PM +0200, Martijn Tonies wrote:
I have a table of properties that is linked to a table f images with a one
property to many images relationship. I have manged this with nested
queries but want to try and do it on one line. My current query
$query = SELECT *
No I want all the properties only one regardless of how many images are
attached to them. Think I need a distinct in there somewhere,
- Original Message -
From: Jon Ribbens [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, May 09, 2007 6:56 PM
Subject: Re: Query problem
how do I return a single row per property even if it has 3 or 4 images
attached to it.
Please reply to the list instead of directly to me.
You could do a:
select p.from properties p where exists (select i.* from images i
where i.property_id = p.property_id)
I have a table of properties
Dan,
Actually you were on the right track. I changed your suggested query
to the following and it seems to work and is a lot quicker.
SELECT id, subject, updated FROM mrldisc WHERE updated SUBDATE(NOW
(), INTERVAL 48 HOUR) AND mainthread = 'T' ORDER BY updated DESC
LIMIT 50
Thanks.
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
Regards,
André
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
On 8/3/06, André Hänsel [EMAIL PROTECTED] wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
SELECT download FROM table WHERE username='user' ORDER BY time DESC
For a specific username:
SELECT username, time, download
FROM table
WHERE username = 'someusername'
ORDER BY time DESC
LIMIT 5
Dan
On 8/3/06, André Hänsel [EMAIL PROTECTED] wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per
@lists.mysql.com
Betreff: Re: Query problem
For a specific username:
SELECT username, time, download
FROM table
WHERE username = 'someusername'
ORDER BY time DESC
LIMIT 5
Dan
On 8/3/06, André Hänsel [EMAIL PROTECTED] wrote:
Hi,
I have a table logging downloads (time, username
-
Von: Dan Buettner [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. August 2006 20:15
An: André Hänsel
Cc: mysql@lists.mysql.com
Betreff: Re: Query problem
For a specific username:
SELECT username, time, download
FROM table
WHERE username = 'someusername'
ORDER BY time DESC
LIMIT 5
At 03:08 PM 8/3/2006, André Hänsel wrote:
Hi,
I have a table logging downloads (time, username, download).
Now I'd like to have the last 5 downloads per user.
Can someone tell me a solution (or what to search for)?
Regards,
André
--
MySQL General Mailing List
For list archives:
-Ursprüngliche Nachricht-
Von: Miles Thompson [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. August 2006 21:56
An: mysql@lists.mysql.com
Betreff: Re: Query problem
At 03:08 PM 8/3/2006, André Hänsel wrote:
I have a table logging downloads (time, username, download).
Now
André Hänsel wrote:
-Ursprüngliche Nachricht-
Von: Miles Thompson [mailto:[EMAIL PROTECTED]
Gesendet: Donnerstag, 3. August 2006 21:56
An: mysql@lists.mysql.com
Betreff: Re: Query problem
At 03:08 PM 8/3/2006, André Hänsel wrote:
I have a table logging downloads (time, username
On 8/3/06, André Hänsel [EMAIL PROTECTED] wrote:
Hi Dan, hi Obed,
of course I have no specific username, I want the last 5 downloads of each
distinct username in the table. :)
i was thinking a lot... and i can't find the solution but maybe yo
can do somthing like this
select
Barry wrote:
Nenad Bosanac schrieb:
Hi I have one problem that i can`t resolve.
still need advice or is it solved?
IF!!! you need IF!! :)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Nenad Bosanac schrieb:
Hi
I have one problem that i can`t resolve.
still need advice or is it solved?
--
Smileys rule (cX.x)C --o(^_^o)
Dance for me! ^(^_^)o (o^_^)o o(^_^)^ o(^_^o)
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
Hi
I have one problem that i can`t resolve.
I have 3 tables
TABLE `predmet` (
`PredmetID` int(10) unsigned NOT NULL
auto_increment,
`BrojPredmeta` int(10) unsigned NOT NULL default
'0',
`VrstaPredmetaID` int(10) unsigned NOT NULL default
'0',
`KorisnikID` int(10) unsigned NOT NULL
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all the authors who aren't connected with
that particular book.
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
- Original Message -
From: John Meyer [EMAIL PROTECTED]
To: List: MySQL mysql@lists.mysql.com
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need to find all
Rhino wrote:
- Original Message - From: John Meyer [EMAIL PROTECTED]
To: List: MySQL mysql@lists.mysql.com
Sent: Tuesday, May 30, 2006 5:09 PM
Subject: Query problem
Setup
TITLES:
TITLE_ID
AUTHORS:
AUTHOR_ID
TITLE_AUTHOR:
(TITLE_ID,AUTHOR_ID)
Problem:
Given a title, I need
FROM form15 f15
WHERE f15.Form15SampleTube6RnaBarcode IN ('01D2V','01DH6'))as abc
Cheers :)
Neeraj Black Bits
-Original Message-
From: Luke [mailto:[EMAIL PROTECTED]
Sent: Wednesday, May 24, 2006 9:36 AM
To: mysql@lists.mysql.com
Subject: Query problem: UNION in subquery
Hello!
I
]; mysql@lists.mysql.com
Sent: Wednesday, May 24, 2006 2:16 AM
Subject: RE: Query problem: UNION in subquery
Hi Luke..
Try this
SELECT ObjectId FROM
(SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId,
f15.Form15PatientID AS PtId FROM form15 f15
WHERE f15.Form15SampleTube1RnaBarcode
Hello!
I have a problem using UNIONs inside subqueries. I have simplified my
query to make it more readable/understandable.
The question is about the right syntax.
1.
This works fine /UNION/
(SELECT f15.Form15SampleTube1RnaBarcode AS ObjectId,
f15.Form15PatientID AS PtId FROM form15
On Wed, 8 Mar 2006 10:12:22 - [EMAIL PROTECTED] wrote:
snip one column select query
but I have two other filters which may or may not be chosen. (area, and
interest).
$query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%' AND
area='area' AND interest='interest' ORDER
I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type;
but I have two other filters which may or may not be chosen. (area, and
interest).
I am fairly new to sql and am now getting into the area of slightly more
complex queries.
At present my query is
$query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type;
but I have two other filters which may or may not be chosen. (area, and
interest).
one solution (may not be the best but would work) would be to use 'like'
instead of '=' and then put wildcards %%$var % around the variable so
that if it is not there then it wount effect the query.
Ade
[EMAIL PROTECTED] wrote:
I am fairly new to sql and am now getting into the area of
On 3/8/06, Adrian Bruce [EMAIL PROTECTED] wrote:
one solution (may not be the best but would work) would be to use 'like'
instead of '=' and then put wildcards %%$var % around the variable so
that if it is not there then it wount effect the query.
Yeah, I use this kind of trick for SELECTs
[EMAIL PROTECTED] wrote:
I am fairly new to sql and am now getting into the area of slightly
more complex queries.
At present my query is
$query = SELECT * FROM $table_name WHERE sname LIKE '$search_string%'
ORDER BY fname $type;
but I have two other filters which may or may not be chosen.
You originally mention your UNION doesn't work but you did not
specify the query. This is a simple or query, or union. You can do
either:
select CaseType_idCaseType,Sizes_idsizes,qty from CaseType_has_Sizes
where (qty=1 and Sizes_idsizes=2) or (qty=1 and Sizes_idsizes=4);
or
select
Sheeri,
Thanks for the help. I tried your sample queries, but they dont really
return what I'm looking for. I think I've found a solution though.
Given the contents of a case, I'm looking for a unique case id, basicially I
want to search for a case if it exists once I've decided the
Hello, I'm having a hell of a time figuring this query out, maybe someone
can point me in the right direction.
I have a table which lists the case configurations for cases of items. Each
case will have a different combination of sizes e.g. Case 002 has 2 size 5,
2 size 7 and 2 size 8 items.
What
Hi Conor,
The table you showed us has 2 primary keys, which is not possible.
Can you do a SHOW CREATE TABLE on *each* table?
-Sheeri
On 2/8/06, Conor McTernan [EMAIL PROTECTED] wrote:
Hello, I'm having a hell of a time figuring this query out, maybe someone
can point me in the right
Sheeri,
The table I'm searching on has a composite primary key since it's mapping an
N:M relationship between Cases and Sizes.
Here's the create statement for the table I'm searching on:
DROP TABLE IF EXISTS `CaseType_has_Sizes`;
CREATE TABLE `CaseType_has_Sizes` (
`CaseType_idCaseType`
Hello.
Perhaps this will work (depends on the version of MySQL you're using):
select question_id
, count(*)
from Records
group by question_id
having question_id not in (
select distinct question_id
from Records r
Hi,
An alternative for any MySQL version (from 3.23.??) would be:
SELECT r1.question_id,count(r1.member_id)
FROM Records r1
LEFT JOIN Records r2 ON r1.question_id=r2.question_id
AND r2.member_id=member_id
WHERE
Hello,
I have a simple Records table with two columns, member_id and question_id.
The object of the query is to retrieve the question_id, as well as how many
times it's been answered - as long as the current user hasn't answered it
(member_id). So, the query shouldn't return any
Hello,
I have master-detail tables and I would like to delete in one statement master
record and all detail records but not every master record has details.
MySQL versions 4.1.10 and higher.
Could someone help me, please, to create such a query?
Example:
CREATE TABLE `master_tbl` (
`ID`
What about
DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON
master_tbl.ID=detail_tbl.ID WHERE .
T.R.
Dušan Pavlica napsal(a):
Hello,
I have master-detail tables and I would like to delete in one statement master record and all detail records but not every master
On 21/12/2005, Dušan Pavlica wrote:
Hello,
I have master-detail tables and I would like to delete in one
statement master record and all detail records but not every master
record has details. MySQL versions 4.1.10 and higher. Could someone
help me, please, to create such a query?
.
- Original Message -
From: Tomas Rasek [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Wednesday, December 21, 2005 11:12 AM
Subject: Re: Delete query problem
What about
DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON
master_tbl.ID=detail_tbl.ID WHERE .
T.R
:
- Original Message - From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets
(id,from,department,subject,body
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
Jeff [EMAIL PROTECTED] wrote on 11/29/2005 11:42:34 AM:
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
Nevermind, found that usig `from` works.
Jeff
-Original Message-
From: Jeff [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 29, 2005 11:43
To: mysql@lists.mysql.com
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining
Jeff wrote:
tickets(id,from,department,subject,body,lastaction,lastpost,priority,sta
tus,created,fromname,lastpostname,attach,ct,uniq,notify,replyto)
values(null,'jmckeon','1','test','test
test',unix_timestamp(now()),'[EMAIL PROTECTED]
[EMAIL
Many Many wrong SQL syntax error check your symbol (') becareful it 'very
important .
You can do that.
Cheer!!
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps
You can use backticks ( ` ) to escape the names:
INSERT INTO `tickets` ( `id` , `from` , `departement` .
hth,
melanie
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Subject: Insert query problem
Date: Tue, 29 Nov 2005 11:42:34 -0500
All,
I can't get this query to run, it keeps
- Original Message -
From: Jeff [EMAIL PROTECTED]
To: mysql@lists.mysql.com
Sent: Tuesday, November 29, 2005 11:42 AM
Subject: Insert query problem
All,
I can't get this query to run, it keeps compaining that there is a
problem:
The Query:
insert into
tickets(id,from,department
Hello.
You should solve the issue with server crashes. I'm not familiar with JDBC,
and if changing the values of parameters with SET statement doesn't work
with JDBC, probably somebody clever on the list could help you. You may
forward your message to:
http://lists.mysql.com/java
Hi,
Yes the server dies during the queries from JDBC.
Regarding the client parameters, what if the client doesn't have mySQL
installed?
Amir
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC
Hello.
Does SHOW STATUS executed from JDBC client return increased values of
this parameters? Could your server die during queries from JDBC (check the
error log)? Sometimes you should increase interactive_timeout as well. A lot of
variables usually could be changed using SET statement. See:
Hi,
Sometimes when querying mySQL 4.1.11 on Linux machine I get the error
Lost connection to MySQL server during query. Here are the symptoms
1. When running the query from the server it returns OK
2. When running the query from another machine using the mySQL
query browser it
Hi,
This is driving me nuts, please tell me is this a bug or a problem wiht my
query:
jappz_guestbook(owner_cno, sent_datetime, is_secret, accepted)
jappz_member_profile(cno, pic_name)
jappz_guestbook's owner_cno and jappz_member_profile's cno are the same
what i need to do is select *
Ok, Thanks for all Roger.
-Mensaje original-
De: Roger Baklund [mailto:[EMAIL PROTECTED]
Enviado el: viernes, 22 de abril de 2005 4:06
Para: Dto. Sistemas de Unitel
CC: mysql@lists.mysql.com
Asunto: Re: Query Problem
Dto. Sistemas de Unitel wrote:
You don't understand me, I refer
?
Thanks for your help, you have been very helpful for me.
Roberto
-Mensaje original-
De: Roger Baklund [mailto:[EMAIL PROTECTED]
Enviado el: miércoles, 20 de abril de 2005 18:30
Para: mysql@lists.mysql.com
CC: Dto. Sistemas de Unitel
Asunto: Re: Query Problem
Dto. Sistemas de Unitel wrote:
Hi
Dto. Sistemas de Unitel wrote:
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize they as the same index. I have
changed the row name and now is working fine, but I have a little question,
How can I use indexes with
PROTECTED]
Enviado el: jueves, 21 de abril de 2005 18:17
Para: mysql@lists.mysql.com
CC: Dto. Sistemas de Unitel
Asunto: Re: Query Problem
Dto. Sistemas de Unitel wrote:
Hi Roger,
You are ok, there was an index problem in one table, they name of the rows
wasn't equal and MySQL didn't recognize
Dto. Sistemas de Unitel wrote:
You don't understand me, I refer that if in a table I use productos.prod_id
and in other table indexes.id if I can use this two fields like the same
index, because when I named the two equal, the index start to work fine.
There should be no problem with joining two
Hi,
Im trying to make a querythat need
to search throught a table and have to search different terms, and SUM their
Rank (is for a small search engine I have to design), this is the table:
Table Indexes
ID bigint
ID_Termino -bigint
Rank double
Table Terminos
ID_Termino bigint
Dto. Sistemas de Unitel wrote:
[...]
something like
/indexes.id=productos.prod_id and indexes.id_termino=terminos.id_termino
and termino=computer and termino=intel/ I know that is impossible,
but maybe there is another way to make that).
Yes, there is another way. You _can_ join the same table
Hi Roger,
That was just I need. The order isnt like you say:
++-+---++---+-+-
++---+-+
| id | select_type | table | type | possible_keys | key | key_len
|
Dto. Sistemas de Unitel wrote:
Hi Roger,
That was just I need. The order isnt like you say:
++-+---++---+-+-
++---+-+
| id | select_type | table | type |
in the message, i.e. if
the title is the same, I do not want it to be printed again...
Any ideas?
From: sol beach [EMAIL PROTECTED]
Reply-To: sol beach [EMAIL PROTECTED]
To: Xristos Karvouneas [EMAIL PROTECTED]
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 12:33:24 -0800
http://www.catb.org/~esr
in the message, i.e. if
the title is the same, I do not want it to be printed again...
Any ideas?
From: gerald_clark [EMAIL PROTECTED]
To: Xristos Karvouneas [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 14:49:45 -0600
Xristos Karvouneas wrote:
Dear All,
I
: gerald_clark [EMAIL PROTECTED]
To: Xristos Karvouneas [EMAIL PROTECTED]
CC: mysql@lists.mysql.com
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 14:49:45 -0600
Xristos Karvouneas wrote:
Dear All,
I am faced with the following problem: I have got three tables -
book,author and authorbook
ideas?
From: sol beach [EMAIL PROTECTED]
Reply-To: sol beach [EMAIL PROTECTED]
To: Xristos Karvouneas [EMAIL PROTECTED]
Subject: Re: Query Problem
Date: Tue, 15 Mar 2005 12:33:24 -0800
http://www.catb.org/~esr/faqs/smart-questions.html
It would help a lot to get answers if you shared the description
Nick Zukin [EMAIL PROTECTED] wrote on 03/14/2005 05:22:38 PM:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the
vendors
and the products. There is
Dear All,
I am faced with the following problem: I have got three tables - book,author
and authorbook - containing information about books and authors (some books
have multiple authors). I want to do a query that would print information
like:
Title 1 Author 1
Author 2
Title 2
Xristos Karvouneas wrote:
Dear All,
I am faced with the following problem: I have got three tables -
book,author and authorbook - containing information about books and
authors (some books have multiple authors). I want to do a query that
would print information like:
Title 1 Author 1
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the vendors
and the products. There is nothing more than the vendor and product ids in
the vendorproducts
What are the results?
sk
On Mon, 14 Mar 2005 14:22:38 -0800, Nick Zukin [EMAIL PROTECTED] wrote:
I'm trying to do a multitable query and am having problems.
I have three tables: vendors, products, and vendorproducts. The
vendorproducts table creates a many to many relationship between the
Because, with the '%keyword%' operator, you're going to match any of
those columns that contain the keyword inside of it. This can be a
little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
you might try 'keyword%' so that 'apple' returns true for 'apples',
'apple juice', 'apple
On Mon, 14 Mar 2005 15:12:18 -0800, Scott Klarenbach wrote
Because, with the '%keyword%' operator, you're going to match any of
those columns that contain the keyword inside of it. This can be a
little confusing as 'ef' will return true on 'abcdefghijk'? Instead,
you might try 'keyword%' so
1 - 100 of 323 matches
Mail list logo