|No such thing as a small change|
Require assistance with a queryby Ashley Jordan (Novice)
|on Oct 14, 2013 at 11:23 UTC||Need Help??|
Ashley Jordan has asked for the
wisdom of the Perl Monks concerning the following question:
i am currently trying to make a script which will update a table based on the results of 2/3 selects previously executed in the script?</p?
I am relatively new to this and believe the SET would be best for this,
can you advise on the below?
This is the part i am looking at,
I would pretty much like to update a field in table A only if that field in the table = A, what i will be updating it to is the content within a field in Table B ( that field must also contain the word test within another field in Table B)
I hope this is clear what i would like to achieve, if not please let me know!
Update: Resolved. made a mistake :)