| From: | "Eric Holmstrom" <eric(at)rocketindustries(dot)com(dot)au> |
|---|---|
| To: | <pgsql-general(at)postgresql(dot)org> |
| Subject: | Php help |
| Date: | 2003-12-11 06:39:48 |
| Message-ID: | 001101c3bfb1$9282fb40$1400a8c0@eric |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | CSN | 2003-12-11 06:44:01 | sequences not renamed with tables |
| Previous Message | Joe "Nuke Me Xemu" Foster | 2003-12-11 05:36:38 | Re: Making a tree with "millions and millions" of dynamic nodes |