PHP SQL serialize Search

 

function getTecherEmailHistory($teacher_name, $school_id) {

$teacher_name_length = strlen($teacher_name);

$school_id_length = strlen($school_id);

$sql = "

SELECT *

FROM your_table_name

WHERE form_value LIKE '%s:9:\"school_id\";s:$school_id_length:\"$school_id\";%'

AND form_value LIKE '%s:16:\"students_teacher\";s:$teacher_name_length:\"$teacher_name\";%'";

return $sql;

}

result sql

SELECT *

FROM your_table_name

WHERE form_value LIKE '%s:9:"school_id";s:3:"509";%'

AND form_value LIKE '%s:16:"students_teacher";s:15:"DELAUP ADVISORY";%'