sql - Increasing query performance for mysql longtext with like -


as production support developer looking data in mysql db, find myself querying column has type longtext , holds lots of data (100k+ rows each 1000 characters or more of text). when use operator wildcards, query takes hours return.

is there can query or table speed up?

thanks in advance help.


Comments

Popular posts from this blog

c# - HttpResponseMessage System.InvalidOperationException -

sql - Postgresql error: "failed to find conversion function from unknown to text" -