'Update data only if the letter is not in front

My Data:

TAn
Ants
TAr
Arm
TogA



UPDATE sample SET sample_data = REPLACE(sample_data , 'A', 'a');

The above shows my data and the SQL code i am using to change A to a. However i only want to change A to a on if A is not the first letter. How can i accomplish this in MySQL?

mysqlsql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions