SQL LIKE語法

• facebook

$st = $db->prepare("SELECT qnsn_title, qnsn_label, qnsn_meno, qnsn_is_stat, qnsn_status FROM questionnaire_section WHERE qnsn_title LIKE :qnsn_title AND qnsn_label LIKE :qnsn_label");


(欄位名 LIKE 欄位變數)   AND  (欄位名 LIKE 欄位變數)






$st->execute(array( ':qnsn_title' => '%'. $data['qnsn_title'] . '%',
                            ':qnsn_label' => '%'. $data['qnsn_label'] . '%',
                            ));


%為前後可有字
以單引號及句號隔開 SQL