remove all numeric characters from column mysql

by

You can write a user defined function, where in you can write your logic of replacement or you can try :

Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(Replace(column,'9',''),'8',''),'7',''),'6',''),'5',''),'4',''),'3',''),'2',''),'1',''),'0','')

More Related Contents:

  1. ‘IF’ in ‘SELECT’ statement – choose output value based on column values
  2. 1052: Column ‘id’ in field list is ambiguous
  3. How to do a batch insert in MySQL
  4. Count the occurrences of DISTINCT values
  5. Codeigniter – multiple database connections
  6. JOIN queries vs multiple queries
  7. Is the primary key automatically indexed in MySQL?
  8. Storing Data in MySQL as JSON
  9. MySql: MyISAM vs. Inno DB! [closed]
  10. MySQL: Cloning a MySQL database on the same MySql instance
  11. DOs and DONTs for Indexes [closed]
  12. How to change the default port of mysql from 3306 to 3360
  13. “where 1=1” statement [duplicate]
  14. How to insert images from database?
  15. Is there an SQLite equivalent to MySQL’s DESCRIBE [table]?
  16. When to use MyISAM and InnoDB? [duplicate]
  17. Alternative to using LIMIT keyword in a SubQuery in MYSQL
  18. How to insert a file in MySQL database?
  19. How do I rename a MySQL database (change schema name)?
  20. Foreign key to one of many tables?
  21. Find date range overlaps within the same table, for specific user MySQL
  22. Rename a table in MySQL
  23. What’s the recommended way to connect to MySQL from Go? [closed]
  24. How to store Query Result in variable using mysql
  25. How to find all the relations between all mysql tables?
  26. How to speed up sql queries ? Indexes?
  27. #1130 – Host ‘localhost’ is not allowed to connect to this MySQL server
  28. How to Get True Size of MySQL Database?
  29. MySQL: Computed Column
  30. mySQL regex in the where clause

Leave a Comment