/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 vote221 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL
13 votes254 views3 answers
Mysqldump structure only
SQL
0 vote204 views1 answer
How to create a new db from dumb file mysql
SQL
0 vote195 views2 answers
Oracle sql for each row
SQL
0 vote193 views1 answer
Dump db only triggers mysql
SQL
11 votes199 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote174 views0 answer
SQL
5 votes217 views3 answers
Day of week postgresql
SQL
8 votes176 views3 answers
Duplicate entry
SQL
0 vote173 views1 answer
How to create an SQL save method in ruby
SQL