Error when selecting values with like and not like MySql

Error when selecting values with like and not like MySql

I'm trying to get every name from students, that contains a space character but doesn't contain "der"

I'm trying to get every name from students, that contains a space character but doesn't contain "der"

When i try to do

select * from students where name like "% %" and not like "% der %

it makes this error: "SELECT" is no valid input at this position for this server version, expecting: '(', WITH

Im using MySql Workbench. It works until i put in "and not like" in the query

Angular 9 Tutorial: Learn to Build a CRUD Angular App Quickly

What's new in Bootstrap 5 and when Bootstrap 5 release date?

Brave, Chrome, Firefox, Opera or Edge: Which is Better and Faster?

How to Build Progressive Web Apps (PWA) using Angular 9

What is new features in Javascript ES2020 ECMAScript 2020

What are the differences between Standard SQL and Transact-SQL?

In this article, we'll explain syntax differences between standard SQL and the Transact-SQL language dedicated to interacting with the SQL

SQL Full Course - SQL Tutorial For Beginners - MySQL Essentials - SQL Training

This SQL Full Course video will cover all the topics of SQL starting from scratch. This video is great for beginners who want to learn SQL and for advanced people to brush up their skills.