sample my table field contains the text
table data
| name | route |
|---|---|
| A1 | data1 data2 data6 data7 |
| A2 | data7 data6 data5 data4 data2 |
| A3 | data2 data5 data6 data7 data8 data9 |
| A4 | data1 data2 data7 |
| A5 | data1 data2 data4 data6 data7 |
how do we query tho show the field contains data2 and data7 in sequence sample output
| name | route |
|---|---|
| A1 | data1 data2 data6 data7 |
| A3 | data2 data5 data6 data7 data8 data9 |
| A4 | data1 data2 data7 |
| A5 | data1 data2 data4 data6 data7 |
line 2 not include because data7 and data2 not in sequence help anyone ...
CodePudding user response：
You can use the LIKE operator:
SELECT yourcolumn
FROM yourtable
WHERE yourcolumn LIKE '