13,468
edits
Data cleaning: Difference between revisions
Jump to navigation
Jump to search
→check if field contains value
| Line 18: | Line 18: | ||
== check if field contains value == | == check if field contains value == | ||
( | # MySQL: {{kbd | key = SELECT * FROM table_name WHERE LENGTH(TRIM( column_name )) != 0;}} [http://sqlfiddle.com/#!2/9b01e/5/0 demo] | ||
== remove first, last or certain characters from text == | == remove first, last or certain characters from text == | ||