Hi everyone. I'm trying to create a certain MySQL query but I'm not sure how to
do it. Here is a stripped down version of the result I'm aiming for. I'm pretty
new to queries that act on multiple tables, so apologize if this is a very
stupid question.
I have one table (data) that has two
To: MySql
Subject: Help needed on query on multiple tables
Hi everyone. I'm trying to create a certain MySQL query but I'm not sure
how to do it. Here is a stripped down version of the result I'm aiming
for.
I'm pretty new to queries that act on multiple tables, so apologize
-Original Message-
From: Michael Stroh [mailto:st...@astroh.org]
Sent: June 3, 2010 11:24 AM
To: MySql
Subject: Help needed on query on multiple tables
Hi everyone. I'm trying to create a certain MySQL query but I'm not sure
how to do it. Here is a stripped down version
...@astroh.org]
Sent: June 3, 2010 11:55 AM
To: Steven Staples
Cc: 'MySql'
Subject: Re: Help needed on query on multiple tables
Thanks! That did it perfectly!
Michael
On Jun 3, 2010, at 11:45 AM, Steven Staples wrote:
How about this?
SELECT
`first_table`.`names
I have a table like this one:
+-+---+---+
| uid | username | query |
+-+---+---+
| 1 | someuser | %qu1% |
| 2 | anotheru | bla% |
+-+---+---+
I get a string from external source, let's say the string is 'blahblah'.
Now I need a query
Hi,
Now I need a query which will take the values from column
'query', treat them as patterns for matching and return
row(s) which match the given string 'blahblah'. In this
example, the matched data is obviously in second row.
(bla% matches blahblah)
Do I make any sense? Is
are required.
Note this will always do a full table scan, so if your table is big, it will
be slow.
..chris
- Original Message -
From: thor [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, April 23, 2002 4:22 AM
Subject: Help needed on query
I have a table like this one
I am working on a mysql database with many large tables (1.5 million rows on
some) and came across a beeg problem.
I have need for a query like this:
mysql select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
panel, null as first_pcrp, null as second_pcrp, null as prb_seq, null as
that.
- Original Message -
From: Bryan Coon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 1:20 PM
Subject: Help needed with Query
I am working on a mysql database with many large tables (1.5 million rows
on
some) and came across a beeg problem.
I have need for a query
Okay, here is the full monty from the database regarding the query in
question, any suggestions on how to improve any of it are greatly
appreciated!
Also, if any more info is needed, just let me know.
Thanks!
Bryan
QUERY:
mysql select distinct subsnp_pk as sqnmid, c.chrom, chrompos, source as
cause some VERY weird join results, and may be your problem. Try adding in
the join clause in the where clause.
- Original Message -
From: Bryan Coon [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Friday, April 27, 2001 2:52 PM
Subject: RE: Help needed with Query UPDATE INFO
Okay, here
11 matches
Mail list logo
