Select fields containing at least one non-space alphanumeric character

Posted by zzapper on Stack Overflow See other posts from Stack Overflow or by zzapper
Published on 2010-04-20T11:57:50Z Indexed on 2010/04/20 12:03 UTC
Read the original article Hit count: 222

Filed under:

non

|

null

|

empty

|

sql

(Sorry I know this is an old chestnut; I have found similar answers here but not an exact answer)

These are frequent hand written queries from a console so I is what I am looking for is the easiest thing to type

 SELECT * FROM  tbl_loyalty_card  WHERE CUSTOMER_ID REGEXP "[0-9A-Z]";

or

SELECT * FROM  tbl_loyalty_card  WHERE  LENGTH(CUSTOMER_ID) >0; -- could match spaces

Do you have anything quicker to type even if it's QAD?

© Stack Overflow or respective owner

Related posts about non

Package Dependencies Error in almost every install

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
New to Ubuntu. In the other sofware sources i have "Debian 4.0 eth" officially supported "non-us.debian.org/"; etc ... "ppa.launcpad.net" and installing applications has stopped working. I think i first came across this problem after installing Blender 2.58 When using update manager it is prompting… >>> More
C++: Check istream has non-space, non-tab, non-newline characters left without extracting chars

as seen on Stack Overflow - Search for 'Stack Overflow'
I am reading a std::istream and I need to verify without extracting characters that: 1) The stream is not "empty", i.e. that trying to read a char will not result in an fail state (solved by using peek() member function and checking fail state, then setting back to original state) 2) That among… >>> More
How to configure non-admin accounts to install updates of non-microsoft applications using Active Di

as seen on Server Fault - Search for 'Server Fault'
How to configure non-admin users to allow them to install updates for Java and Adobe Acrobat Reader (or any other application which may need such privileges) without needing for administrator password on Windows 7. Updates for Microsoft products install without problems. This can be Active Directory… >>> More
R ggplot2: Arrange facet_grid by non-facet column (and labels using non-facet column)

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a couple of questions regarding facetting in ggplot2... Let's say I have a query that returns data that looks like this: (note that it's ordered by Rank asc, Alarm asc and two Alarms have a Rank of 3 because their Totals = 1798 for Week 4, and Rank is set according to Total for Week 4) … >>> More
What is the rationale to non allow overloading of C++ conversions operator with non-member functio

as seen on Stack Overflow - Search for 'Stack Overflow'
C++0x has added explicit conversion operators, but they must always be defined as members of the Source class. The same applies to the assignment operator, it must be defined on the Target class. When the Source and Target classes of the needed conversion are independent of each other, neither the… >>> More

Related posts about null

How do I fix a noisy input device (Internal Mic)? snd_hda_intel - debug included

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
As the title says, I'm having trouble with a very noisy audio input device - the internal mic or any plugged in mics. So far I've narrowed it down to an problem in ALSA since my debug info is showing a lot of "null" values. Can anyone help? Debug Info: http://www.alsa-project.org/db/?f=e0c6fb7e10624bf7691aa2b405cf0d3968e56c63 Exert… >>> More
So which null equals this null, that null? maybe this null, or is it this null?

as seen on SQL Blogcasts - Search for 'SQL Blogcasts'
Tuning takes many routes and I get into some interesting situations and often make some exciting finds, see http://sqlblogcasts.com/blogs/grumpyolddba/archive/2010/05/17/just-when-you-thought-it-was-safe.aspx for an example. Today I encountered a multitude of Foreign Key constraints on a table, now… >>> More
MySql query optimization help

as seen on Stack Overflow - Search for 'Stack Overflow'
I have few queries and am not able to figure out how to optimize them, QUERY 1 select * from t_twitter_tracking where classified is null and tweetType='ENGLISH' order by id limit 500; QUERY 2 Select count(*) as cnt, DATE_FORMAT(CONVERT_TZ(wrdTrk.createdOnGMTDate,'+00:00','+05:30'),'%Y-%m-%d')… >>> More
MySQL Database Query Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I need your help!!!. I need to query a table in my database that has record of goods sold. I want the query to detect a particular product and also calculate the quantity sold. The product are 300 now, but it would increase in the future. Below is a sample of my DB Table #---------------------------- #… >>> More
Null check error message as "is null" or "was null"

as seen on Stack Overflow - Search for 'Stack Overflow'
When doing null checks in Java code, and you throw IllegalArgumentExceptions for null values, what kind of message template do you use? We tend to use something like this public User getUser(String username){ if (username == null){ throw new IllegalArgumentException("username is null");… >>> More