Hi,
How can I update a column where the first letter begins with 'M' and adjust
it so that column ends with 'M' instead. So something like 'UPDATE table SET
column = 'xxxM' WHERE column = 'Mxxx'. I hope this explains what I am trying
to achieve!
Thanks
--
PHP Database Mailing List
: [PHP-DB] Help With An UPDATE Query Please
Hi,
How can I update a column where the first letter begins with 'M' and
adjust
it so that column ends with 'M' instead. So something like 'UPDATE table
SET
column = 'xxxM' WHERE column = 'Mxxx'. I hope this explains what I am
trying
to achieve
Hi,
I have (among others) two DATE columns in a table; Booking_Date and
Booking_Completion_Date. How can I run a query that updates
Booking_Completion_Date to be 2 days after Booking_Date where
Booking_Completion_Date is NULL?
Many thanks
--
PHP Database Mailing List (http://www.php.net/)
To
Presuming you have the date in your PHP code you could simply add 172800
(seconds in 2 days) to the current value and insert it in the same way
as you are doing with your current dates.
If you post how you're inserting your dates, what format you're using
and stuff like that then you'll
[Forwarded for Paxson Jr. because this was only sent to me.]
you can also easily use the mysql date functions
http://www.mysql.com/doc/en/Date_and_time_functions.html
On 05. Feb 2004, at 11:23 Uhr, Stuart Gilbert wrote:
Presuming you have the date in your PHP code you could simply add
172800
I have (among others) two DATE columns in a table; Booking_Date and
Booking_Completion_Date. How can I run a query that updates
Booking_Completion_Date to be 2 days after Booking_Date where
Booking_Completion_Date is NULL?
UPDATE table SET Booking_Completion_Date = Booking_Date + INTERVAL
Hi,
I am making some alterations to my Database. I have a table called projects
and a table called Work_Types. Projects currently contains the name of the
work type (Work_Type) but now I want to change this so it contains the
Work_Type_ID, is it possible to update Projects with one query?
Thanks
It all depends on what database server (and version) you are using. I'm
not really sure what you are asking, and could use a little more detail
about the tables and what are needing to do.
On Sat, 4 Oct 2003 13:45:56 +0100, Shaun spoke thusly about [PHP-DB]
Help With Another UPDATE Query
.
On Sat, 4 Oct 2003 13:45:56 +0100, Shaun spoke thusly about [PHP-DB]
Help With Another UPDATE Query Please!:
Hi,
I am making some alterations to my Database. I have a table called
projects
and a table called Work_Types. Projects currently contains the name of
the
work type (Work_Type) but now