Combine multiple column values in to single value in SQL select statement

Question

I have an autocomplete field where user can enter lastname firstname middlename in the same order.

Using lastname firstname middlename (as a term) I have to show the autocomplete dropdown.

On my database I have 3 columns for firstname lastname and middlename. Now I have to compare 3 column values (asc_lastname, asc_firstname, asc_middlename) of same row with user input (term).

Here is the SQL query. Please correct my mistake.

$rs = mysql_query( "select asc_lastname, asc_firstname, asc_middlename from issio_asc_workers INNER JOIN issio_workers_asc_sc_list 
ON  issio_asc_workers.lname_fname_dob=issio_workers_asc_sc_list.lname_fname_dob where issio_workers_asc_sc_list.center_id='$cid' 
AND issio_workers_asc_sc_list.center_user_type = '31' AND issio_workers_asc_sc_list.center_status <> 'deleted' AND 
(issio_asc_workers.asc_lastname+' '+issio_asc_workers.asc_firstname+' '+issio_asc_workers.asc_middlename) 
LIKE '". mysql_real_escape_string($term) ."%'  ORDER BY issio_asc_workers.lname_fname_dob ASC LIMIT 0,10");

Is it possible to compare 3 column values at a time using a SQL query like

 select * 
 from table 
 where (column1+''+column2+''column3) like 'this is good'

Sorry for my poor sentences.

oh I am sorry removed jquery. As i am using jquery autocomplete plugin I added jquery also. — crazytech
– crazytech, Commented Jun 29, 2012 at 22:27
What you are trying seems a bit odd. Give us a concrete example of what you type and what you expect — Samson
– Samson, Commented Jun 29, 2012 at 22:28

Jocelyn · Accepted Answer · 2012-06-29 22:56:54Z

3

Try this query:

SELECT * FROM your_table WHERE CONCAT(column1, ' ', column2, ' ', column3) LIKE '%this is good%'

Documentation for CONCAT

answered Jun 29, 2012 at 22:56

Jocelyn

11.4k11 gold badges47 silver badges63 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

crazytech Over a year ago

Thnak you so much. Thanks for documentation link.

Collectives™ on Stack Overflow

Combine multiple column values in to single value in SQL select statement

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related