<div>
Not equal to in SQL is written as &lt;&gt;&nbsp;not !=
</div>


Not equal to in SQL is written as <> not !=

<div>
Hi there,<br />
<br />
assuming you want to select non empty values try this.<br />
<br />
<br />
-TheDoctor<br />

<pre><code id="code-1177036">SELECT DISTINCT serv_nam, serv_lab  FROM ANI_SIT_ARC WHERE serv_nam IS NOT NULL AND serv_nam &lt;&gt; '' ORDER BY id</code></pre>
</div>


Hi there,

assuming you want to select non empty values try this.


-TheDoctor


SELECT DISTINCT serv_nam, serv_lab  FROM ANI_SIT_ARC WHERE serv_nam IS NOT NULL AND serv_nam <> '' ORDER BY id

<div>
<div class="content wysiwyg-content">
SELECT DISTINCT serv_nam, serv_lab &nbsp;FROM ANI_SIT_ARC WHERE serv_nam != \&quot;\&quot; ORDER BY id<br />
<br />
Doesnt work, do U see why ?<br />
Thank you
</div>
</div>


SELECT DISTINCT serv_nam, serv_lab  FROM ANI_SIT_ARC WHERE serv_nam != \"\" ORDER BY id

Doesnt work, do U see why ?
Thank you

DISTINCT MYSQL QUERY

Networking hardware includes the physical devices facilitating the use of a computer network. Typically, networking hardware includes gateways, routers, network bridges, modems, wireless access points, networking cables, line drivers, switches, hubs, and repeaters. But it also includes hybrid network devices such as multilayer switches, protocol converters, bridge routers, proxy servers, firewalls, network address translators, multiplexers, network interface controllers, wireless network interface controllers, ISDN terminal adapters and other related hardware.

Networking Hardware-Other

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.