Hi There,
This should be obvious but my mind is blank.
Can I find all courses with "MATH" in the title?
In SQL it would be SELECT FROM courses WHERE fullname LIKE %MATH% or SELECT FROM courses WHERE CONTAINS(fullname, '%MATH%')
Neither:
$course = $DB->get_record_sql('SELECT FROM {course} WHERE Contains(fullname , ? )' , array('%MATH%');or
$course = $DB->get_record_sql('SELECT FROM {course} WHERE fullname LIKE ?)' , array('%MATH%');
work.
Any ideas gratefully received.
Best Regards
Dave
$sql = 'SELECT FROM {course} WHERE '.$DB->sql_like('fullname', ':value', false); // false = not case sensitive.
$params = ['value' => '%math%'];
$DB->get_record_sql($sql, $params);
Do you have debugging switched on? Neither of those lines is valid PHP syntax so you're probably getting a fatal error. I'd expect something like the second one to work but it's missing the field list in the SQL and there's a rogue parenthesis at the end.
Something like this should work:
$course = $DB->get_record_sql('SELECT * FROM {course} WHERE fullname LIKE ?' , array('%MATH%'));but if you need cross-database compatibility you might be better off using the sql_like() method:$course = $DB->get_record_sql('SELECT * FROM {course} WHERE ' . $DB->sql_like('fullname', '?'), array('%MATH%'));or even just$course = $DB->get_record_select('course', $DB->sql_like('fullname', '?'), array('%MATH%'));This would work:
$rec = $DB->get_records_select(
'course',
$DB->sql_like('fullname', ':within', false, false),
['within' => '%algebra%']
);
And this as well:
$rec = $DB->get_records_sql(
"SELECT * FROM {course} WHERE ".$DB->sql_like('fullname', ':within', false, false),
['within' => '%algebra%']
);