tags:

views:

8

answers:

0

Hello,

I am trying to create a query which checks if a value exists in a column. The column constists of json_encoded values (like, ["3","10"])

function totPerWorkshop($id){ $q = "SELECT * FROM tblWorkshop WHERE workshops = $id"}

Does something like SELECT * FROM tblWorkshop WHERE in_array($id, workshops); exists?

Any suggestions