/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

2 votes292 views1 answer
Oracle sql merge
SQL
22 votes290 views4 answers
Mysql date_format
SQL
0 vote280 views1 answer
Mysql workbench view
SQL
0 vote287 views1 answer
Sqlite explain plan
SQL
0 vote282 views1 answer
Sqlcmd no headers
SQL
11 votes280 views2 answers
Turn off safe mode mysql
SQL
0 vote301 views1 answer
Default order by in mysql
SQL
1 vote263 views1 answer
Column with prefix in sql
SQL
2 votes285 views1 answer
Mysql now format
SQL
0 vote295 views1 answer
Oracle last connexion
SQL