I am trying to query exact number in array inside text field in sql so for example can return which is not good because i would like to get the arrays that contain 1 Answer You could use JSON functions:

find exact number in text field in sql

I am trying to query exact number in array inside text field in sql so for example

SELECT tbl_campaigns.s_id,a_list_fk_i_id_tbl_affiliates
FROM tbl_campaigns
WHERE a_list_fk_i_id_tbl_affiliates LIKE '%1%'

​x
 
SELECT tbl_campaigns.s_id,a_list_fk_i_id_tbl_affiliatesFROM tbl_campaignsWHERE a_list_fk_i_id_tbl_affiliates LIKE '%1%'​

can return

[3,8,7,11]

 
[3,8,7,11]​

which is not good because i would like to get the arrays that contain 1

You could use JSON functions:

SELECT s_id,a_list_fk_i_id_tbl_affiliates 
FROM tbl_campaigns
WHERE JSON_CONTAINS(a_list_fk_i_id_tbl_affiliates, 1)

 
SELECT s_id,a_list_fk_i_id_tbl_affiliates FROM tbl_campaignsWHERE JSON_CONTAINS(a_list_fk_i_id_tbl_affiliates, 1)​