I want put LIMIT and ORDER, in following query. how is it?
ORDER BY tour_foreign.id asc
LIMIT $offset, $coun_page
In the this query:
SELECT
@rownum := @rownum + 1 rownum,
tour_foreign.id,
tour_foreign.name,
tour_foreign.airline,
MIN(tour_foreign_residence.name_re) AS name_re,
tour_foreign.service,
tour_foreign.date_go,
tour_foreign.date_back,
tour_foreign.term,
tour_foreign.useradmin_submit,
tour_foreign.date_submit,
GROUP_CONCAT( tour_foreign_residence.name_re
ORDER BY tour_foreign_residence.name_re
SEPARATOR '، '
) AS name_re_all
FROM tour_foreign
INNER JOIN tour_foreign_residence
ON ( tour_foreign.id = tour_foreign_residence.relation )
JOIN (SELECT @rownum := 0) r
GROUP BY tour_foreign.id
HAVING name LIKE '%" . $find . "%'
OR airline LIKE '%" . $find . "%'
OR name_re_all LIKE '%" . $find . "%'
OR service LIKE '%" . $find . "%'
OR date_go LIKE '%" . $find . "%'
OR date_back LIKE '%" . $find . "%'
OR term LIKE '%" . $find . "%'
OR useradmin_submit LIKE '%" . $find . "%'
OR date_submit LIKE '%" . $find . "%'