I have column where the values in that column will have some name in capital alphabet the length is 10 char but if the name is small
The values in this field will be padded with leading spaces (char 'b') when < 10 chars.
E.g. name ABC will be
"bbbbbbbABC"
When I print, I should print only ABC.
REPLACE should do the trick: http://dev.mysql.com/doc/refman/5.0/en/string-functions.html#function_replace
If you got a table 'MyTable' with a column 'MyName' then the SQL statement would be:
SELECT REPLACE(MyName,'b','') FROM MyTable
There are many ways to do this but the best is SELECT REPLACE(MyName,'b','') FROM MyTable, suggested by René Berndt
thanks for taking interest in my response. Off-course i can give you other way but need little bit of clarification. What are the cases where above given method (way) fails.
https://dev.mysql.com/doc/refman/8.0/en/string-functions.html#function_replace
- Badges
- Science topic
- Similar topics
- Mathematics
- Statistics
- Statistical Analysis
- Data Analysis
- Dataset
- Big Data