[SQL] How to SELECT all rows that contain a keyword.
How do I have SQL return all rows that contain a selected keyword. I know how to SELECT from a column but what I want to do is have SQL search all columns and return every row that contains the keyword.
For example if I have a table with two columns labeled Car_Color and Wheel_Color with the following data:
And I want to return all rows with the keyword "Red" so I get back:
Is this possible?
Thanks for the help in advance.
Submitted April 30, 2016 at 07:38PM by platypusss
via reddit http://ift.tt/1Nc8osl