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 searc
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;
whe
[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
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
[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 wor
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");
>
>'detail_start_date_y,detail_start_date_m,detail_start_date_d,detail_start_time_h,detail_start_
espond to [EMAIL PROTECTED]
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 th
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
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 Develop
