/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 vote134 views1 answer
Restart sql server command line linux
SQL
1 vote250 views1 answer
Sql injection
SQL
7 votes138 views6 answers
Code: 'er_not_supported_auth_mode', errno: 1251, sqlmessage: 'client does not support authentication protocol requested by server; consider upgrading mysql client', sqlstate: '08004', fatal: true
SQL
0 vote142 views1 answer
Oracle current timestamp insert statement
SQL
4 votes139 views1 answer
Sql delete where in select
SQL
6 votes152 views2 answers
Where clause in sql
SQL
12 votes140 views2 answers
Insert multiple rows from another table sql
SQL
0 vote170 views1 answer
A network or instance-specific error sql server
SQL
0 vote156 views2 answers
Port 5432 is already in use mac
SQL
0 vote142 views1 answer
Set column in all row mysql
SQL