/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 vote170 views1 answer
Which takes more space in a database a datetime or separate date and time columns?
SQL
0 vote163 views1 answer
Xamarin sql lite create table if not exist
SQL
0 vote195 views1 answer
Id INT NOT NULL AUTO_INCREMENT
SQL
0 vote215 views2 answers
Wordpress change url in database
SQL
1 vote151 views1 answer
Create email address from first and last name in sql
SQL
1 vote189 views1 answer
Base64 encode sql server
SQL
2 votes143 views1 answer
Postgresql change value in column
SQL
3 votes141 views1 answer
What is having clause
SQL
0 vote156 views1 answer
Get a list of tables and the primary key
SQL
0 vote280 views1 answer
Mysql delete entire row on condition
SQL