The PostgreSQL (PG) field is separated by a comma "," to determine if a value is included

If there is a student student table

The fields in the Student Table have field course fields with 1,2,3,4,5,6,7 7 courses

CREATE TABLE Student

(

Name varchar (255),

Course varchar (255)

)

INSERT into student (name, course)

Values (' Zhang San ', ' 1,2,5,7 ');

Question one, judge whether Zhang San chose course 2

SELECT * FROM

where name = ' Zhang San '

and String_to_array (course, ', ') @> array[' 2 ']

Question two, judge whether Zhang San chooses the course at the same time 2,6

SELECT * FROM

where name = ' Zhang San '

and String_to_array (course, ', ') @> array[' 2 ', ' 6 ']

This article is from a "simple to rely" blog, so be sure to keep this source http://wenxuehui.blog.51cto.com/12898974/1954697

The PostgreSQL (PG) field is separated by a comma "," to determine if a value is included