I've been coding for over 20 years now! (WOAH, do I feel old)
I've touched just about every resource imaginable under the Sun (too bad they were bought out by Oracle)
A better way to think of the % character in LIKE queries: it is a "find and replace" character. Meaning, anywhere that % is found, it can be replaced by ANYTHING and still match. This also means that it works in the middle, too! So you can have "A%C" and it'll match on "ABC" and "AXC" and "A bob is really awesome C" for example.
Just started a career in tech! I love front-end engineering and design. I aspire to make all sorts of silly/useless apps, and I always have tons of new ideas!
Location
Denver, CO
Education
Flatiron School for Software Engineering
Work
Front-end and Full-stack Software Engineer / Operations Engineer
A better way to think of the % character in LIKE queries: it is a "find and replace" character. Meaning, anywhere that % is found, it can be replaced by ANYTHING and still match. This also means that it works in the middle, too! So you can have "A%C" and it'll match on "ABC" and "AXC" and "A bob is really awesome C" for example.
THANK YOU! I hadn't gotten as advanced as those other % advanced options yet! I appreciate the clarification.