Using LIKE to compare two columns

This query doesn’t return any results, but maybe something like this is not an option in mySQL? I’m wanting it to return results if the member has “XYZ Massage Company” and their brand on file is “XYZ”.


select memberID, brand, businessName from members where (businessName = brand or businessName like brand);

Oh, I got this figured out by adding a concat.


This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.