sethbeckerman5 Staff asked 4 years ago
If my goal is to find out if there is a string in the column. The column has no unique btree index. Which is faster and more efficient: INSTR vs LIKE prefix for varchar in MYSQL, and why?
Or are there other more-efficient methods?
vs
I looked up several questions, but there were only questions and answers about wild cards front and back.
For example,