/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 vote173 views1 answer
Sql server whoami
SQL
7 votes195 views3 answers
How ot change name of column mysql
SQL
0 vote188 views1 answer
Sql query tags
SQL
1 vote175 views1 answer
Add constraint sql
SQL
0 vote176 views1 answer
Database get 10 user aleatory
SQL
0 vote175 views1 answer
Data structures in sql
SQL
0 vote197 views1 answer
Oracle drop type
SQL
3 votes151 views4 answers
Show columns from table
SQL
12 votes173 views10 answers
Google
SQL
5 votes183 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL