/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

0 vote410 views1 answer
Mysql workbench format date
SQL
14 votes376 views2 answers
Install mysqldump
SQL
0 vote378 views1 answer
Mssql dockere
SQL
2 votes364 views1 answer
Oracle apex list connected users
SQL
0 vote356 views1 answer
Postgresql regular expression special characters
SQL
8 votes374 views2 answers
Sqlsrv default port
SQL
0 vote371 views1 answer
Create new schema mysql
SQL
0 vote385 views1 answer
Vbscript connect mssql
SQL
0 vote379 views1 answer
Mysql 5.7 in centos 7
SQL
0 vote365 views2 answers
Jsonb
SQL