/SQL/Get rows from 1 table with other table empty mysql

Get rows from 1 table with other table empty mysql

SELECT students.name, students.lastname, ifnull(courses.course_name, '-') as course_name
FROM students
LEFT JOIN courses
ON courses.id_student=students.id_student 
WHERE students.name LIKE '%$search%'
GROUP BY students.id_student 
ORDER BY students.name, students.lastname, courses.course_name

Source: stackoverflow.com

Similar codes

1 vote386 views2 answers
Sql unique rows
SQL
1 vote239 views1 answer
Incompatible sql_mode=only_full_group_by
SQL
0 vote264 views1 answer
Delete hangfire retries list
SQL
11 votes244 views1 answer
Mysql text type max length
SQL
0 vote224 views1 answer
Mysql query single row
SQL
0 vote228 views1 answer
Sql grant select only
SQL
0 vote216 views1 answer
Ms Sql set us timezone
SQL
0 vote237 views1 answer
What is default mysql database password in linux
SQL
0 vote256 views1 answer
Mysql zerofill
SQL
8 votes277 views2 answers
Default sql server port
SQL