Shorten all customer names in reviews using php one time

[mcpisik]

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!

[dbltoe]

You would probably need to do this in two steps.

The first would be to grab just the first character of the customers_lastname. Something like

SELECT SUBSTRING(SOUNDEX(customers_lastname),1,1) AS FirstChar FROM customers

then

SELECT cCONCAT(customer's_firstname,' ', FirstChar)AS review_name FROM customers

Just random thoughts as to how you might change the reviews code without having to create any mod or new database fields.

Definitely play with this in test mode.

[mcpisik]

Thanks for the ideas. I'll get a test site going and try it out. Cheers.