Please ask the hypothesis that I want to find a string of linked fields bits in MySQL
Which function should I use?
Like saying
"Owogkwoeag Wegaweogkawoeg" "Owogkwwegawegoeag Wegaweogkawoeg" "Owogkwesseseryeag" Wegaweogkawoeg "I'm looking for 190.
As long as I have 190, I'll delete him.
It's only 190.
If 19 or 910 or 91 does not count ....
Reply content:
Please ask the hypothesis that I want to find a string of linked fields bits in MySQL
Which function should I use?
Like saying
"Owogkwoeag Wegaweogkawoeg" "Owogkwwegawegoeag Wegaweogkawoeg" "Owogkwesseseryeag" Wegaweogkawoeg "I'm looking for 190.
As long as I have 190, I'll delete him.
It's only 190.
If 19 or 910 or 91 does not count ....
If you don't want to use LIKE
a fuzzy query, you can use the LOCATE()
or POSITION()
function to implement it.
Let's say your table test
is:
ID |
content |
1 |
Owogkwoeag Wegaweogkawoeg |
2 |
Owogkwwegawegoeag Wegaweogkawoeg |
3 |
Owogkwesseseryeag Wegaweogkawoeg |
4 |
Qweqweqweqweqwe 901 |
You can use the following statement to delete test
content
all records in a table that contain a column:
delete from test where LOCATE('190', content);
Or
delete from test where POSITION('190' IN content);