[mysql] 특정 문자열 제외

2020. 7. 27. 17:50

상황

특정 문자열이 들어가지 않은 데이터 조회하고 싶다

SELECT * FROM TABLE WHERE FIELD_NAME NOT LIKE '%STRING%';

[mysql] Select column if string is empty (0)	2020.07.30
[database] Cubrid export MySQL import, migration (0)	2020.07.17
[mysql] Error Code: 1118 Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. This includes storage overhead, check the manual. You have to change some columns to TEXT or BLOBs (0)	2020.07.07
[Mysql] offset, limit (0)	2019.12.19