MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE profiles ( ID INT, 
                        Name VARCHAR(255),
                        email VARCHAR(255),
                        phone VARCHAR(255),
                        facebook VARCHAR(255),
                        instagram VARCHAR(255) );
INSERT INTO profiles VALUES
(  0 , 'Jill'    , 'jill@aol.com'   , '(123)123-1245'  , 'fbjill'   , 'igjill'    ),
(  1 , 'Jack'    , 'jack@aol.com'   , '(123)111-1111'  , 'fbjack'   , 'igjack'    ),
(  2 , 'Bob'     , 'bob@aol.com'    , '(123)222-2222'  , 'fbbob'    , 'igbob'     ),
(  3 , 'jMarie'  , 'igjill@aol.com' , '(123)123-1245'  , 'none'     , 'none'      );
SELECT * FROM profiles;


ID
Name
email
phone
facebook
instagram


0
Jill
jill@aol.com
(123)123-1245
fbjill
igjill

1
Jack
jack@aol.com
(123)111-1111
fbjack
igjack

2
Bob
bob@aol.com
(123)222-2222
fbbob
igbob

3
jMarie
igjill@aol.com
(123)123-1245
none
none


SET @query := 'igjill';
SELECT *,
       MAKE_SET (       (phone = @query) 
                  + 2 * (email = @query) 
                  + 4 * (facebook = @query) 
                  + 8 * (instagram = @query), 'phone', 
                                              'email', 
                                              'facebook', 
                                              'instagram') from_where
  FROM profiles 
HAVING from_where != '';


ID
Name
email
phone
facebook
instagram
from_where


0
Jill
jill@aol.com
(123)123-1245
fbjill
igjill
instagram


SET @query := '%jill%';
SELECT *,
       MAKE_SET (       (phone LIKE @query) 
                  + 2 * (email LIKE @query) 
                  + 4 * (facebook LIKE @query) 
                  + 8 * (instagram LIKE @query), 'phone', 
                                              'email', 
                                              'facebook', 
                                              'instagram') from_where
  FROM profiles 
HAVING from_where != '';


ID
Name
email
phone
facebook
instagram
from_where


0
Jill
jill@aol.com
(123)123-1245
fbjill
igjill
email,facebook,instagram

3
jMarie
igjill@aol.com
(123)123-1245
none
none
email

ID	Name	email	phone	facebook	instagram
0	Jill	jill@aol.com	(123)123-1245	fbjill	igjill
1	Jack	jack@aol.com	(123)111-1111	fbjack	igjack
2	Bob	bob@aol.com	(123)222-2222	fbbob	igbob
3	jMarie	igjill@aol.com	(123)123-1245	none	none