/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 vote236 views1 answer
SQL server select to get sum of hours
SQL
0 vote256 views1 answer
Oracle sql date winter time
SQL
3 votes255 views5 answers
Mysql get last inserted id
SQL
0 vote276 views1 answer
Create table as select sql server error
SQL
0 vote255 views1 answer
Sum value by month sql
SQL
0 vote268 views1 answer
Import excel to sql
SQL
0 vote258 views1 answer
Pl sql round
SQL
0 vote278 views1 answer
Sql query use select name inside where clause
SQL
1 vote264 views1 answer
Tsql create unique index composite
SQL
0 vote259 views1 answer
Mariadb used space
SQL