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

book

Article ID: 57270

calendar_today

Updated On:

Products

DX Infrastructure Management NIMSOFT PROBES

Issue/Introduction

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

Environment

Release:
Component: CAUIM