Let's say I have the following data table named test_table:
| id | col1 | col2 | col3 |
|---|---|---|---|
| 1 | A100 | B200 | C200 |
| 2 | A200 | A200 | C200 |
| 3 | A100 | B200 | C200 |
| 4 | A200 | A200 | C200 |
I would like to select all rows with a "A100" in col1. I tried the following but nothing worked:
SELECT * FROM test_table WHERE col1=A100
SELECT * FROM test_table WHERE A100 IN col1
SELECT * FROM test_table WHERE col1 LIKE "A100"
SELECT * FROM test_table WHERE col1 LIKE "