/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 vote297 views1 answer
Sql find record cannot cast date
SQL
0 vote293 views1 answer
Test sql query
SQL
18 votes289 views4 answers
Uninstall mysql on ubuntu
SQL
0 vote303 views1 answer
Multiple replace value mssql
SQL
0 vote279 views1 answer
MySql Modify Increment
SQL
0 vote305 views1 answer
Drop index in sql
SQL
0 vote279 views1 answer
Sql server order by nulls last
SQL
0 vote297 views1 answer
Sql server on mac m1
SQL
0 vote282 views1 answer
How to create an SQL save method in ruby
SQL
0 vote289 views1 answer
MySQL get all previous date record
SQL