How to search for bad/special/non-printable characters in MySQL

Document ID : KB000057270
Last Modified Date : 14/02/2018
Show Technical Document Details

Introduction

MySQL 5.6/5.6

Searching for bad/special characters when the backend database is MySQL.

Below are some examples:

SELECT * FROM s_qos_data WHERE NOT target REGEXP '[A-Za-z0-9.,-]' and target NOT LIKE '/';

SELECT * FROM nas_transaction_summary WHERE NOT <column> REGEXP '[A-Za-z0-9.,-]'

SELECT * FROM nas_alarms WHERE NOT message REGEXP '[A-Za-z0-9.,-]'

SELECT * FROM s_qos_data WHERE NOT target REGEXP '[A-Za-z0-9.,-]' and target NOT LIKE '/' and? target != ""

select * from cm_computer_system WHERE NOT <column> REGEXP '[A-Za-z0-9.,-]'

SELECT * FROM NAS_NOTES WHERE NOT message REGEXP '[A-Za-z0-9.,-]' and? message != ""



?




Procedure