/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 vote129 views1 answer
Mysql workbench search all tables
SQL
0 vote189 views1 answer
Ubuntu stop mysql from starting on boot
SQL
4 votes167 views4 answers
Sqlite describe table
SQL
0 vote160 views1 answer
Mysql isshow
SQL
0 vote181 views1 answer
Distance calculator from lat long sql query
SQL
6 votes170 views1 answer
What is where clause in sql
SQL
0 vote171 views1 answer
Mysql add root password
SQL
0 vote191 views1 answer
Where date in datetime mysql
SQL
0 vote186 views2 answers
Enter into postgresql database,create user and grant Access
SQL
0 vote174 views1 answer
Sql query interview questions githu
SQL