Not sure I understand what you need?
Can you create a dummy output table of what you would like your result
to look like?
At first glance, from reading your question, it sounds like you simply
want this:
select * from ppc_keywords where keywords like %job% [group by
keywords] order by bid;
I think the most difficult ( if not impossible with just using mysql
query) is the part where you apply your logic as to the most relevant
keyword.
You need to be able to have a mechanism of telling the query which
keyword is the most relevant, ie, human logic says, the one that matches
the search
[snip]
INSERT INTO Customer_Equipment SELECT Customer.ID, Server_ID,
Configuration, Equipment_Type, Group_ID, Location, Rack_Location,
Network_Status_Name, Creator_ID, Primary_IP_Address FROM
Customer_Equipment, Customer WHERE SUBSTRING(Server_ID, 5,4) =
Customer.User_ID;
The select statement
Greetings Jay:
RE: mySQL query help please
I love rules that don't make sense ;-)
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from
[snip]
So if the end result is to have the records selected appended to the
Customer_Equipment table, I have to make a temporary table based on the
characteristics of the Customer_Equipment table... then insert from that
temporary table. Correct?
[/snip]
BINGO! Goofy rules can be frustrating
Hi Chris,
On Fri, 2002-06-14 at 02:08, Chris Kay wrote:
I have a rather longer query which I would like to get all records past todays date.
Here is my query
$ttwo = date(YmdGi);
snip
I've not looked over your query in-depth so I may be off-base here. Try
removing the parentheses from the FROM clause and see if that makes it work.
=C=
*
* Cal Evans
* Journeyman Programmer
* Techno-Mage
* http://www.calevans.com
*
-Original Message-
From: Scott Raley [mailto:[EMAIL
]
To: Scott Raley/LPEC/ASD/SEMCORINC@SEMCOR INC., [EMAIL PROTECTED],
[EMAIL PROTECTED]
cc:
Subject: RE: mysql query help
I've not looked over your query in-depth so I may be off-base here. Try
removing the parentheses from the FROM clause and see if that makes it work.
=C=
*
* Cal
Harpreet writes:
I dont think we can use 'IN' and 'NOT IN' in mysql. Is there an alternative
that would work?
select * from lib_asset_tbl where material_id '' and asset_id in (select
asset_id from lib_copy_tbl)
Help is appreciated.
Regards,
Harpreet Kaur
Software Developer
Crispin