smus

Members
  • Content count

    58
  • Joined

  • Last visited

Community Reputation

0 Neutral

About smus

  • Rank
    Newbie
  1. I need to create a search in a field where there are several delimiters, such as commas, brackets and slashes. I used FIND_IN_SET parameter when there was just single commas, but it doesn't find a substring when I add more delimiters as a search rule: SELECT * FROM field WHERE FIND_IN_SET ($searchquery, searchfield) > 0 SELECT * FROM field WHERE FIND_IN_SET ($searchquery, REPLACE(searchfield, '\', '')) > 0 I've connected the second query to the first using OR