php mysql search

I have written code to list all companies in our database alphabetically.  I have quick links at the top from A-Z and also have one other link that is suppose to get all companies that start with a number or special character.  Does anyone know the SELECT command in MySQL that can search all the companies and list them that begin with a number or special character.  Basically a list of all companies that DO NOT start with a letter.
the-mizAsked:
Who is Participating?
 
Ray PaseurConnect With a Mentor Commented:
Possibly you could use something like SELECT mycompany FROM mtable WHERE mycompany NOT IN (SELECT mycompany FROM mtable WHERE mycompany LIKE ' a%' OR 'b%' OR 'c%'   ... etc

But I think it might be easier to use ALTER TABLE and add a selection column.  You could use the first letter of the company name to load the column, or you could load the column with '1' to indicate a non-letter name.
0
 
the-mizAuthor Commented:
Yes, I thought of those two ideas.  Using the OR statement in the clause will get long, for each letter in the alphabet.  Thought there might be a cleaner way
0
 
Ray PaseurCommented:
I think the cleaner way would be to alter the table.  That is what I would probably do.
0
 
maeltarCommented:
Something like :

SELECT * FROM tableName WHERE NOT columnToCheck REGEXP '[A-Za-z0-9]';

Open in new window


0
 
Ray PaseurCommented:
That WHERE NOT REGEXP might need to be something like '[A-Za-z]{1}.*?' to find the companies like 3-M that start with numbers.  Not quite sure about that regex syntax in MySQL.  I still think I might change the table to add a selection column.  It would depend on the weight of the table scan that would result from the SELECT .. WHERE NOT.

Best to all, ~Ray
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.