Anyone having experience in MySQL and REGEXP ?
I have 1 input field, "what"
Now, the value from the "what" field can contain several substrings and I like each of them to be searched. Can this be done by using REGEXP or do I need to split the "what" input string into arrays before searching ?. Or is there other tricks using the LIKE clause ?
Another issue while talking about REGEXP in MySQL. Let's say I have the input value "e-mail" and the database field contains the value "email". There must be some way to put some variants into the expression to accept the "-" and match the values.
Any examples is welcome.
what = Request.Form("what") WHERE searchwords LIKE ' % " & what & " % ' " WHERE searchwords REGEXP '[[:<:]]"&what&"'"