RE: replace string

2003-03-05 Thread Dillon, John
I want to replace part of a string with something else. I have a table called favorites. This can be done by someone who logs in on the browser with email and password. I'm using php in a web page. Do I use the following syntax: $query_del = "UPDATE favorites REPLACE(favorites,'BitOfStringToRe

RE: Query problem

2002-07-05 Thread Dillon, John
Is it possible to do two temporary tables for authors and publishers and then do a join on the title? -Original Message- From: Jed Verity [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 21:01 To: '[EMAIL PROTECTED]' Subject: Re: R: Query problem I see. Sorry I misunderstood you. You're st

Multiple INNER JOINs

2002-07-05 Thread Dillon, John
Can I just check: should it be OK to do multiple INNER JOINs like this: SELECT * FROM (((table1 INNER JOIN table2 ON table1.anyfield = table2.anyfield) INNER JOIN table3 ON table3.anyfield=table2.anyfield) INNER JOIN table4 on table4.anyfield=table1.anyfield) WHERE... Regards, John sql,query

RE: RE: JOIN specific fields from two tables

2002-07-05 Thread Dillon, John
-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 05 July 2002 17:13 To: Dillon, John Subject: Re: RE: JOIN specific fields from two tables Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the

JOIN specific fields from two tables

2002-07-05 Thread Dillon, John
Can I/how do I SELECT specific fields from different tables with a JOIN query. The documentation only refers to selecting all the fields. Regards, John CONFIDENTIAL: This e-mail, including its contents and attachments, if any, are confidential. If you are not the named recipient please noti

Getting started

2001-04-04 Thread Dillon, John
Statically Compiled MySQLGUI 1.7.4 <../Downloads/mysqlgui/mysqlgui-linux-static-1.7.4.tar.gz> I need to know whether I have to compile or do anything else with the above other than download and unzip it. When I do that (into c:\mysql\ directory) the file mysqlgui is not an application file s