Question about MySQLwhere condition replacement?

Field: ariclecategoryindex? Typearticle value: ariclecategoryindex requirement: comparison? Is the previous self-read content and value equal? I want to delete the content including "Hello" and compare it with each query. how can I write "where? Currently: select * fromw... field: ariclecategory/index? Type = article

Value: ariclecategory/index

Requirement: comparison? Whether the original self-read content and value are equal

I want to remove the content including "Hello" to the comparison during each query. how can I write the where statement?

Currently: select * from whereziduan= 'Ariclecategory/index ';

Reply content:

Field: ariclecategory/index? Type = article

Value: ariclecategory/index

Requirement: comparison? Whether the original self-read content and value are equal

I want to remove the content including "Hello" to the comparison during each query. how can I write the where statement?

Currently: select * from whereziduan= 'Ariclecategory/index ';

select * from where ziduan like 'ariclecategory/index%'

Ariclecategory/index if it is a variable, replace it with a variable
Prefix matching like can be indexed. Suffix matching and fuzzy matching are not supported.

Select * from where ziduan like 'ariclecategory/index % '? What do you mean?

The problem of removing the question mark is to be processed in the program. The SQL where statement can be written as you do now.