/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 vote423 views1 answer
Mysql convert charset
SQL
-1 vote373 views1 answer
Concat two columns in sql server
SQL
0 vote381 views1 answer
SQL: calculate hours from two dates
SQL
1 vote390 views1 answer
Postgres see sequence current state
SQL
5 votes367 views2 answers
Mysqldump password
SQL
1 vote332 views2 answers
Postgresql backup and restore globals and data
SQL
12 votes380 views6 answers
How to install sqlite3 in python
SQL
0 vote377 views1 answer
View psql output in horizontal scrolling
SQL
0 vote340 views1 answer
Get last date join sql
SQL
0 vote343 views1 answer
Can't connect to postgresql mac os
SQL