I have a table in PostgreSQL, and I need to determine if the column contains special characters like #,$,^,&,*,@,! etc. or empty.
#,$,^,&,*,@,!
For example, a table might look like this:
How to write such a request?
Finally, I got a solution
select * from table where column1 ~* '[^a-z0-9]' or column2 ~* '[^a-z0-9]' or column3 ~* '[^a-z0-9]'
Source: https://habr.com/ru/post/1439815/More articles:place the color bar label above the horizontal color bar (instead of below) - matplotlibIncluding previously registered events in a new logging handler - pythonAdding additional fields to hibernate beans that are not fields in the db table - hibernateBusterjs + requirejs + spine, how to write tests? - backbone.jsStuck with Facebook URL Schema Suffix - facebookProgram a button to press at most once every 5 seconds in java - javaCan I solve the subtask of the problem using FishEye Smart Fix? - atlassian-fisheyeGeolocation converter - pythonChecking runtime for pointers - cHow to check Zipcode for USA or Canada in iOS? - regexAll Articles