nested recordset REGEXP not matching strings containing special characters

Hi Ray, hope you can advise on an issue I'm having with a nested recordset - have been Googling all afternoon and can't find anything that will solve this. The recordsets contain course names, and the nested recordset is matching on these course names using a REGEXP. It works fine, except if the course name contains special characters i.e. "Testing & Certification (T&C)" - in that case it doesn't find a match. This is the current nested recordset which sits within the rsTests repeat region:

<?php
$WADACPD = new WA_MySQLi_RS("WADACPD",$connection,1000);
$WADACPD->setQuery("SELECT CPD.CPD_ID, CPD.User_ID, CPD.Course_name, CPD.`Date` FROM CPD WHERE CPD.User_ID = ? AND CPD.Course_name REGEXP ? ORDER BY CPD.`Date` DESC");
$WADACPD->bindParam("i", "".$_SESSION['CPD_ID'] ."", "-1"); //colname
$WADACPD->bindParam("s", "".($rsTests->getColumnVal("Title")) ."", "-1"); //paramTest
$WADACPD->execute();?>

All the 'solutions' I've found so far either return all or no records. Is there a way I can get the REGEXP to also find course names which contain special characters?

Try using:

($rsTests->getColumnVal("Title",false))

Have tried that and it made no difference unfortunately.

You probably need to escape special characters, try:

$WADACPD->bindParam("s", "".(preg_quote($rsTests->getColumnVal("Title",false))) ."", "-1"); //paramTest

Yes, I think that's worked! Will get some users to test as well but it's now showing my test cases - thank you!