my friend wants from me to write two queries for him but really I don't know ,would you please help me?
also there is a table with two column (String Telephone and BIGIN Charge).
the sentences that I want to write a query for that:
one: Reduce the â€œChargeâ€ for all Telephone numbers starting with â€˜123â€™ by 30.
two: Update all the Telephone numbers in the table by adding a â€˜02â€™ in front of it.
** I use MySQL**
What do you have so far? Are you sure this isn't just homework?