solr query exactly similar to mysql like -

solr query exactly similar to mysql like -

hello having problem replicate mysql functionality solr next testcase scenario

when search "ryan decosta" in solr q=xyz:*ryan decosta* solr homecoming document xyz having "ryan decosta","ryan","decosta","dasdecosta","ryaneqwddd","efdefsryan decostadsadsad","ryan decostadsadsad","efdefsryan decosta" etc

when search "ryan decosta" in mysql like xyz="%ryan decosta%" mysql homecoming rows xyz having "ryan decosta","efdefsryan decostadsadsad","ryan decostadsadsad","efdefsryan decosta" not homecoming "ryan","decosta" separately

i don't want "ryan","decosta" separately in search

thanks in advance

see reply here: how same result next mysql query solr?

mysql computes unanchored string match touching every row. solr (and index technology) designed avoid touching every record @ query-time. supports anchored text matching edgengramfilterfactory.

mysql solr