HEXAQ : A friendly question - answer site for IT professionals

MySQL - How to use Regular Expressions in MySQL query ?


0

I have a field in MySQL database.

How can I get non-alpha numeric characters replaced with underscore ("_").

Here is an example:

Source Data

©2013 Google - Terms & Privacy (The registered trademark symbol, designated by ® (the circled R) 1 Music; 2 Linguistics; 3 Technology

Expected Output

_2013 Google _ Terms _ Privacy The registered trademark symbol designated by _ the circled R) 1 Music 2 Linguistics_ 3 Technology

Can I use Regular Expression in MySQL? If Yes, plz provide sample code.

Â
asked
 


≡ Total 0 Answer

Enter your reply here
Answer Preview:
Viewed: 977 times
Asked on: 9/14/2013
Permalink
Topics in this question
  2
  2
Search Question
Similler Questions