Размер видео: 1280 X 720853 X 480640 X 360
Показать панель управления
Автовоспроизведение
Автоповтор
Why LIKE '%(space)DIAB1%' works for ACNE(space)+DIAB100 in the test case? I though DIAB1% is a string starts with DIAB1.
There’s another % at the start of the search string meaning anything could come before the search term. In this case, what we’re checking is ' DIAB1‘ being anywhere in the string. The space makes sure we’re looking at a new word starting.
![LeetCode 196: Delete Duplicate Emails [SQL]](http://i.ytimg.com/vi/V0-33jrJgwo/mqdefault.jpg)
![LeetCode 196: Delete Duplicate Emails [SQL]](/img/tr.png)
![LeetCode 1341: Movie Rating [SQL]](http://i.ytimg.com/vi/AUYkIomulaw/mqdefault.jpg)
![LeetCode 1321: Restaurant Growth [SQL]](http://i.ytimg.com/vi/6p9lY_YftsE/mqdefault.jpg)
Why LIKE '%(space)DIAB1%' works for ACNE(space)+DIAB100 in the test case? I though DIAB1% is a string starts with DIAB1.
There’s another % at the start of the search string meaning anything could come before the search term. In this case, what we’re checking is ' DIAB1‘ being anywhere in the string. The space makes sure we’re looking at a new word starting.