Hi to all, does anybody knows the command to search for ? in one or all fields
f.e title contains "Sch?brunn"
If you mean the literal question mark character, you should precede it with a slash: "Sch\?brunn"
If you mean how to search for a pattern that has any single character in that position, use a period: "Sch.brunn"
If you are trying to use this to search for multiple extended character possibilities, search for 0 or more extra characters with a period+asterisk:
thank you the first question is solved with \?
Is it possible to search for ? in words but not at the end
f.e I would like to find
Eine bisher ?bersehene Erw?hnung der Tigerpferde aus dem Altertum
Transitive inference in animals: Reasoning or conditioned associations?
Sure. Search for:
Separating this, we are looking for a literal question mark (\?) followed by zero or more characters (.*) followed by a single non question mark ([^\?]) that occurs at the end of the string ($).
There are numerous regular expression references available for more information.
Hi Knut, Rick gave you already good advice.
You may also want to have a look at:
and the linked tutorials & intros to regular expressions.
Learning a little bit about regular expressions is time well worth spent since they're generally useful (e.g. almost any good text editor has support for basic regular expressions, and so does MySQL). Personally, I don't know how I could live without them. :-)
Sign up for the SourceForge newsletter:
You seem to have CSS turned off.
Please don't fill out this field.