/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 vote299 views1 answer
Create table with timestamp mysql youtube
SQL
2 votes357 views1 answer
Find column in all stored procedures sql server
SQL
6 votes290 views1 answer
Update left join mysql
SQL
0 vote320 views1 answer
Oracle current timestamp insert statement
SQL
2 votes319 views1 answer
Datetrunc
SQL
0 vote315 views1 answer
Wordpress database query change url
SQL
1 vote304 views2 answers
Mysql filter by date mount
SQL
6 votes340 views2 answers
Mysql convert timestamp to date
SQL
0 vote332 views1 answer
Bitmap join index
SQL
3 votes301 views4 answers
Show databases in sql server
SQL