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