MySQL Like Query
I currently have the following code
$sql = "select * from messages where id = '".$_POST['id']."' or from = '". $_POST['from'] ."' or subject = '". $_POST['subject'] ."' or message = '". $_POST['message'] ."' ORDER BY id DESC";
What I would like to do is have a LIKE on subject and message, non-case sensitive but not sure how to do it?
Can someone tell me how?