[RESOLVED] Merge 2 Queries into 1 Query

[transfield]

Hello,
I want to merge the 2 queries below into 1 query in order to simplify my coding. How do I do it? My code is below. Thank you very much for your guidance.

<?php
$query1=("SELECT SUBSTRING_INDEX(full_add, ' ', 5) AS keywords FROM houses WHERE full_add like '%$Text_Box_17%'");

$query2=("SELECT * FROM houses WHERE full_add like '%$Text_Box_17%'");
?>

[NogDog]

$query = "SELECT *, SUBSTRING_INDEX(full_add, ' ', 5) AS keywords FROM houses WHERE full_add like '%$Text_Box_17%'";

(However, it's generally a good idea to explicitly list each column you want to select rather than using "*", in order to avoid retrieving more data than you actually need and to make it clear exactly what columns are being retrieved in what order.)

[transfield]

Thanks for your advice & your coding help. I appreciate it. God bless you man :-)