Listing non alphabet records – MySQL

Posted by mkhairul - January 7, 2010 at 12:01:18 pm - No Comments

 Categories: Tips



I know this is rather simple, but I thought I’d just put it here because I haven’t been posting quite as often as I would like.

There’s this application, where it needs to list companies by alphabets. Click on ‘A’ it displays all companies that starts with ‘A’ or ‘a’.

So there’s this ‘Others’. Companies that starts their name with other symbols.

A simple regex will do the job.

SELECT * FROM table WHERE column NOT REGEXP '^[a-zA-Z]'

GimpStyle Theme design by Horacio Bella.