<div>
Assuming you cannot follow Ray's solution of redesigning the table then LIKE would be the simplest option<br />
<br />

<pre><code id="code-20-40947942-1">SELECT * FROM serials WHERE field LIKE '%12345%'</code></pre>
The problem with this is that it will find records with the following numbers<br />

<pre><code id="code-20-40947942-2">12345,23456
123456,123</code></pre>
So to refine it you could do<br />

<pre><code id="code-20-40947942-3">SELECT * FROM serials 
  WHERE 
    field LIKE '12345,%' OR -- Starts with
    field LIKE '%,12345' OR -- Ends with
    field LIKE '%,12345,%' OR  -- In the middle
    field = '12345' -- On its own</code></pre>
</div>


Assuming you cannot follow Ray's solution of redesigning the table then LIKE would be the simplest option



SELECT * FROM serials WHERE field LIKE '%12345%'

The problem with this is that it will find records with the following numbers


12345,23456
123456,123

So to refine it you could do


SELECT * FROM serials 
  WHERE 
    field LIKE '12345,%' OR -- Starts with
    field LIKE '%,12345' OR -- Ends with
    field LIKE '%,12345,%' OR  -- In the middle
    field = '12345' -- On its own

<div>
Many thanks Ray and Julian. I like your way best Ray - it seems the most robust and accurate!
</div>


Many thanks Ray and Julian. I like your way best Ray - it seems the most robust and accurate!

<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I have a field in a table 'serials' that has comma delimited content. &nbsp;e.g. &nbsp;12345,23456,34567<br />
This field in each row does not contain the same numbers. &nbsp;So there are no overlaps of numbers.<br />
<br />
If i was to perform an SQL query on the table to give the result of which record has a certain number, what would be the best query string to use?<br />
<br />
Thanks<br />
Paul
</div>
</div>


Hi,

I have a field in a table 'serials' that has comma delimited content.  e.g.  12345,23456,34567
This field in each row does not contain the same numbers.  So there are no overlaps of numbers.

If i was to perform an SQL query on the table to give the result of which record has a certain number, what would be the best query string to use?

Thanks
Paul

MySQL PHP search - best practice

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.

MySQL Server

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.