/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 vote322 views1 answer
Return size of tables in mysql
SQL
4 votes322 views3 answers
Mysql modify foreign key
SQL
0 vote372 views1 answer
Sql find gaps in date ranges
SQL
31 votes327 views4 answers
How to get duplicate records with multiple field in sql
SQL
0 vote411 views1 answer
Stop and start mysql
SQL
0 vote338 views4 answers
What is unique key in sql
SQL
0 vote338 views2 answers
Alter table add multiple columns mysql
SQL
0 vote332 views1 answer
Create a table from one field of another table
SQL
0 vote325 views2 answers
Nested query
SQL
6 votes330 views2 answers
Find mysql version linux
SQL