<div>
Yes, I thought of those two ideas. &nbsp;Using the OR statement in the clause will get long, for each letter in the alphabet. &nbsp;Thought there might be a cleaner way
</div>


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

<div>
I think the cleaner way would be to alter the table. &nbsp;That is what I would probably do.
</div>


I think the cleaner way would be to alter the table.  That is what I would probably do.

<div>
Something like :<br />
<br />

<pre><code id="code-20-37002504-1">SELECT * FROM tableName WHERE NOT columnToCheck REGEXP '[A-Za-z0-9]';</code></pre>
<br />

</div>


Something like :



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


<div>
That WHERE NOT REGEXP might need to be something like '[A-Za-z]{1}.*?' to find the companies like <i>3-M</i> that start with numbers. &nbsp;Not quite sure about that regex syntax in MySQL. &nbsp;I still think I might change the table to add a selection column. &nbsp;It would depend on the weight of the table scan that would result from the SELECT .. WHERE NOT.<br />
<br />
Best to all, ~Ray
</div>


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

<div>
<div class="content wysiwyg-content">
I have written code to list all companies in our database alphabetically. &nbsp;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. &nbsp;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. &nbsp;Basically a list of all companies that DO NOT start with a letter.
</div>
</div>


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.

php mysql search

PHP is a widely-used server-side scripting language especially suited for web development, powering tens of millions of sites from Facebook to personal WordPress blogs. PHP is often paired with the MySQL relational database, but includes support for most other mainstream databases. By utilizing different Server APIs, PHP can work on many different web servers as a server-side scripting language.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.