SQL select

alirezaok

i have a field with 4 record for example:
1,4,5,6
10,16,5
3,66,8
2,6,7

i want to selcet records where this field has 6 number.
for this example result must be select first and last reacord.

what is sql statment for this job?

select * from tablename where filedname ............?

tomhath

It depends on how the table was created. Please post the CREATE TABLE statement or the column definitions.

alirezaok

CREATE TABLE `book` (
`id` INT NOT NULL AUTO_INCREMENT ,
`numbers` VARCHAR( 255 ) NOT NULL ,
PRIMARY KEY ( `id` ) 
);

Kudose

You should not store comma delimited data in a single column. There are several reasons for this, but your issue at hand is a great example.

You should look into database normalization.

tomhath

I agree with Kudose, create a child table and the rest is easy:

CREATE TABLE `numbers` (
`bookid` INT NOT NULL  ,
`theNumber`  INT NOT NULL
);
...
select book.id, numbers.theNumber
from book 
inner join numbers
  on numbers.bookid = book.id
where numbers.theNumber = 6