MySQL Where condition replacement question?

Field: Ariclecategory/index?type=article

Value: Ariclecategory/index

Need: Compare? Previous self-read content and values are equal

Want every query, will include say hello to the content to remove in comparison, how to write where?

Current: SELECT * from where ziduan = ' ariclecategory/index ';

Reply content:

Field: Ariclecategory/index?type=article

Value: Ariclecategory/index

Need: Compare? Previous self-read content and values are equal

Want every query, will include say hello to the content to remove in comparison, how to write where?

Current: SELECT * from where ziduan = ' ariclecategory/index ';

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

Ariclecategory/index if it is a variable, replace it with a variable
The like that the prefix matches is available for indexing. Suffix matching and fuzzy matching are not available.

SELECT * from where Ziduan like ' ariclecategory/index% '? I don't know what that means.

Get rid of the question mark. This kind of data processing is done in the program, and the SQL where is as you write now.

