/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 vote262 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
2 votes211 views1 answer
Mysql cannot delete or update a parent row
SQL
0 vote224 views1 answer
Mysql enter ubuntu
SQL
0 vote207 views1 answer
Check psql validity function
SQL
0 vote217 views1 answer
Oracle synonym procedure dblink
SQL
23 votes242 views5 answers
Sql substring
SQL
6 votes214 views2 answers
Join vs union
SQL
2 votes211 views1 answer
Mariadb select multiple rows into one column
SQL
0 vote227 views1 answer
Mssql disable foreign key constraint
SQL
1 vote224 views1 answer
Delete specific row in sql
SQL