/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 vote348 views2 answers
Csv into data postgres
SQL
0 vote357 views1 answer
To Create directory
SQL
0 vote371 views1 answer
Nvl2 syntax
SQL
0 vote341 views1 answer
Call procedure in wordpress
SQL
0 vote379 views1 answer
Convert LDAP Epoch to Date
SQL
0 vote377 views1 answer
Mod in sql
SQL
5 votes382 views3 answers
DBMS_OUTPUT.PUT_LINE
SQL
2 votes373 views4 answers
Check timezone of mysql database
SQL
0 vote361 views1 answer
Sql convert datetime to year
SQL
17 votes350 views3 answers
Cast in sql server
SQL