/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 vote217 views1 answer
Get enginge db mysql
SQL
1 vote165 views1 answer
Snowflake rename column name
SQL
3 votes155 views1 answer
Show index table
SQL
14 votes165 views4 answers
Import database through command line
SQL
5 votes160 views2 answers
Mysql import gzip db
SQL
1 vote193 views1 answer
Check current sequence value postgres
SQL
0 vote156 views1 answer
Dbms_output sql developer
SQL
2 votes102 views1 answer
Sql select in list
SQL
0 vote145 views1 answer
How to connect pgadmin with excel
SQL
0 vote167 views1 answer
Postgresql import a database of gzip
SQL