Hi,
You can do this by full text searching.
Full text seaching will be 10 times faster than.
Suppose your property name is " Power Bridge " and City name is
"London" in this case any one can fill complete address like "Power
bridge london" or some one can fill like above situation. So in this
case you have to put like on two field and if data is quite large then
your query will be hanged. To overcome with satiation you have to
implement full text searching.
It is very easy to implement . Please follow the instruction written below
Full-text Search is a feature introduced to MySQL in version 3.23.23.
This is how I used it to fix my problem:
I started out with an update to my table:
ALTER TABLE property ADD FULLTEXT(Address, City);
This set ups our Full-text index. The (Address, City) part tells us
that we can search the City and Property for keywords later on. We’ll
find out how to use this later, once we’ve overcome a potential
problem.
<?php
MySQL_connect("hostname", "username", "password");
MySQL_select_db("our_db");
$query = "
SELECT * FROM Property
WHERE MATCH(Address, City) AGAINST ('London')
";
$sql = MySQL_query($query);
/* output results */
?>
On Mon, Jun 29, 2009 at 8:23 PM, Emiliano Boragina
<emiliano.boragina@xxxxxxxxx> wrote:
>
> Hi, I must do e finder for properties... I know do a simple search but
> not a search like this with more one possibility, with all or some
> fields full... How do it?
> Thanks a lot
>
> --
> + _
> Emiliano Boragina //
> Diseño y Comunicación /////////////
> + _
> emiliano.boragina@xxxxxxxxx ////
> 15 40 58 60 02 //////////////////////////
> + _
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
--
The Gate of Change is Locked on the INSIDE.
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
