/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 vote211 views1 answer
Mysql update all record removing 2 hours from column
SQL
0 vote138 views1 answer
How to set all the min and sec data to zero in sql server
SQL
4 votes139 views1 answer
Oracle delete last row
SQL
1 vote145 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote136 views1 answer
Mysql read row
SQL
0 vote147 views1 answer
Wordpress delete post revisions older than date "sql"
SQL
1 vote154 views1 answer
Mysql order by desc null last
SQL
7 votes153 views1 answer
Alter sequence set current value oracle
SQL
1 vote170 views1 answer
Postgresql pass array in function
SQL
1 vote141 views1 answer
Sql into vs insert into
SQL