Hi,
I have code in that shortens a customer name, to just first name and first initial of surname.
Works well.
I would like to, using phpmyadmin, change the existing customer_name to first name with last initial, in the reviews tab database.
(For existing reviews made before I added the code)
Anyone able to provide a bit of sql that i could enter?
As example Nicola Smith would become Nicola S, just in the Reviews database.
Thanks!
Bookmarks