My question is sort of two-fold. The first being which version of my sql is Toad DP 3.5 on?
I’m not much of a mysql coder but I am using my local storage connection for a project. What is the proper syntax for using a ‘like’ clause on another field name, versus actual text. For example, let’s say the two fields are phone numbers (a.phone) and (b.phone).
How should the syntax look for a “where a.phone like b.phone”