<div>
<br />
//DB connections<br />
$search_str = &quot;somename or lastname&quot; ;<br />
$query =&quot;SELECT concat(firstname,lastname)<wbr /> as m FROM user WHERE firstname LIKE '%$search_str%'&quot; ;<br />
$result = mysql_query($query) ;<br />
while($row = mysql_fetch_object($result<wbr />)) {<br />
echo $row-&gt;m ;<br />
}
</div>


<div>
<div class="content wysiwyg-content">
Im having a problem with a search function. What i want is to put multiple datafields from a table into a variable wich i, in the sql can search for with LIKE '%search_str%'<br />
<br />
So far i have:<br />
<br />
SELECT CONCAT(firstname, ' ', lastname) as full_name FROM tablename WHERE full_name LIKE '%search_str%'<br />
<br />
It seams like i cant search for the concated field full_name. Any way to do this? Or is there another way to collect different datafields int one variable 'fictiv field' i can search for? This is the simplyfied sql to show what i mean, i have many other records taken out with the same criterias.
</div>
</div>


Im having a problem with a search function. What i want is to put multiple datafields from a table into a variable wich i, in the sql can search for with LIKE '%search_str%'

So far i have:

SELECT CONCAT(firstname, ' ', lastname) as full_name FROM tablename WHERE full_name LIKE '%search_str%'

It seams like i cant search for the concated field full_name. Any way to do this? Or is there another way to collect different datafields int one variable 'fictiv field' i can search for? This is the simplyfied sql to show what i mean, i have many other records taken out with the same criterias.


//DB connections
$search_str = &quot;somename or lastname&quot; ;
$query =&quot;SELECT concat(firstname,lastname) as m FROM user WHERE firstname LIKE &#39;%$search_str%&#39;&quot; ;
$result = mysql_query($query) ;
while($row = mysql_fetch_object($result)) {
echo $row-&gt;m ;
}

php+mysql+concat

Im having a problem with a search function. What i want is to put multiple datafields from a table into a variable wich i, in the sql can search for with LIKE &#39;%search_str%&#39;

So far i have:

SELECT CONCAT(firstname, &#39; &#39;, lastname) as full_name FROM tablename WHERE full_name LIKE &#39;%search_str%&#39;

It seams like i cant search for the concated field full_name. Any way to do this? Or is there another way to collect different datafields int one variable &#39;fictiv field&#39; i can search for? This is the simplyfied sql to show what i mean, i have many other records taken out with the same criterias.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.