Re: [Toledoh] where AND / OR
Hi Tim,
Try putting quotes around the LIKE value: LIKE "1"
LIKE supports these "wildcard" characters:
% Matches any number of characters, even zero characters
_ Matches exactly one character
So you can do things like this:
LIKE "%dave%" - matches "dave" anywhere in the string
LIKE "604%" - must start with 604
LIKE "%!" - must end in !
LIKE "1%2" must start with 1 and end in 2
So in CMSB some of the multi-value fields are tab separated. So in MySQL you can represent a tab as \t, so we sometimes search for a value in a tab separated list like this: LIKE "%\t
My Value\t%"
And you can also say: NOT LIKE to return rows that don't match the pattern.
Hope that helps! Let me know if you have any other questions about that.
Dave Edis - Senior Developer
interactivetools.com