/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 vote102 views1 answer
Mysql count grouped rows
SQL
4 votes131 views1 answer
Phone number sql
SQL
0 vote131 views1 answer
Alter domain sql
SQL
1 vote108 views1 answer
Psql connections
SQL
0 vote101 views1 answer
If null don't update
SQL
0 vote117 views1 answer
Oracle date summer time
SQL
0 vote117 views1 answer
Mysql select where field is a value
SQL
11 votes118 views1 answer
Mysql text type max length
SQL
8 votes125 views1 answer
Unique vs primary key
SQL
1 vote151 views1 answer
Postgresql append array
SQL