How to combine 3 different columns in 1 mysql table?
There are three different tables. I do something like smart search, which offers options. For example writing in the search box “shop” , system there's gonna to offer me the results that I had in mind: email firstname.lastname@example.org the shop24 store name or a product name little shop. All data is stored in different tables. I want the query to 1 table consisting of 3 columns : EMAIL( email@example.com,firstname.lastname@example.org), SHOP(shop24, null), NAME(null is null(no matching name)). It is clear that every column will selected through LIKE. But how it to thrust in table 1 below in the columns was only unique values without repetitions? Left join requires the attribute on, and I have to add 3 columns to the table and empty space to fill in the null. Give an example or a ready-made request please. Can be in the form of procedure