I have a
query formula that looks into a table and pulls names for example:
A B 1 john, andrew blah 2 drew, mike blah
I want it to show me all of the rows that involve
drew, the query formula is
select where A contains 'drew'. Both rows would show up, because
drew, but if I use the formula
select where A = 'drew', nothing would show up because it is looking for an exact match. What do I do here? I was thinking maybe regular expression would help, but how would I do it?