I have a custom field for storing educational data. A person's degree is stored as either Btech or B.Tech or B.Tech. so what should I give in search option so that I can get all 3 in my result in a single search?
You can use basic pattern valid in
LIKE operator of sql where clause.
For Eg - Using
%tech% would result in all three rows.
Similarly you can use
To find more about search strings - see Pattern Matching in MySQL (AFAIK you can use only
LIKE patterns here not