Re: Php help - Mailing list pgsql-general

From Robert Treat
Subject Re: Php help
Date
Msg-id 1071583996.1792.8305.camel@camel
Whole thread Raw
In response to Php help  ("Eric Holmstrom" <eric@rocketindustries.com.au>)
List pgsql-general
First, your subject line is misleading and likely to get your post
ignored. Your problem isn't related to PHP, it is an sql problem. (And
as such probably more appropriate for the pgsql-sql list, but whatever)

I think what you're trying to do is:

UPDATE rocket SET search = partno WHERE partno ilike '5R%';

Robert Treat

On Thu, 2003-12-11 at 01:39, Eric Holmstrom wrote:
> Hi there,
>
> Ive been reading but not getting far, so thought i would ask here. IN
> SQL im trying to do this.
>
> What its meant to do is look in Column partno. Then check if there are
> any part numbers starting with 5R. Once it done that  it should insert
> the value 5R RACING into the blank SEARCH column inline with it.
>
>
>
> Ive Tried
>
> Select partno LIKE "5R%" INSERT INTO rocket (search) VALUE (5R RACING)
>
> Recieved the error
>
> You have an error in your SQL syntax near 'INSERT INTO rocket (search)
> VALUE (5R RACING)' at line 1
>
>
>
> any ideas how 2 do this? or point me to reading material to help?
>
> Thankyou
>
>
> Eric Holmstrom
>

--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Any commercial shopping cart packages using
Next
From: "B. van Ouwerkerk"
Date:
Subject: Re: Any commercial shopping cart packages using