Advertisement:

Author Topic: search like '%%'  (Read 583 times)

terra

  • Newbie
  • *
  • Posts: 12
search like '%%'
« on: March 23, 2015, 02:03:34 am »
hi,

where can I insert a like '%%' to find part of the word?

ie: pizzeria

search for pizz not show

thanks

teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: search like '%%'
« Reply #1 on: March 23, 2015, 02:33:50 am »
Hi,

That would be quite expensive in terms of time if you have a lot of ads. ???

Here it is a partial solution with pretty good performance, not "%pattern%", only "pattern%", but that seems good enough to me:

http://forums.osclass.org/general-help/important-how-to-have-a-really-funcional-search/msg112640/#msg112640

Regards

terra

  • Newbie
  • *
  • Posts: 12
Re: search like '%%'
« Reply #2 on: March 23, 2015, 09:16:30 pm »
thank you

teseo

  • Hero Member
  • *****
  • Posts: 6169
Re: search like '%%'
« Reply #3 on: March 24, 2015, 02:28:54 am »
You're welcome :)

Please add [SOLVED] to the title of this thread.