Search by part of string

[moisesbr]

Hi 

 

I trying the search using the query below:

 

$result = mysql_query("SELECT * FROM certificado WHERE nome='$name'  ") or die (mysql_error());

 

 

If I look for Jose da Silva in table,it only works if I type full name. "Jose da Silva" .

How can I make the query work by typing part of search string, as "Jose da", "Jose d", etc.

 

Moises

 

 

[.josh]

SELECT * FROM certificado WHERE nome LIKE '%{$name}%'

[moisesbr]

SELECT * FROM certificado WHERE nome LIKE '%{$name}%'

 

Very useful command, but if name is Elton John, and I search "John",   Elton John is found as well.

 

I need Elton John is found only if a type: "Elto"  "Elton" "Elton J", etc.

 

Moises

[QuickOldCar]

If searched for John and Elton John comes up, the search works, it wouldn't work so well otherwise.

 

If you needed more control and wanted to spend the time more advanced and multiple search queries, fulltext search is a better way.

http://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html

 

Fulltext Boolean can do things matching against,within,excluding,stemming,weighted and so on.

http://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html

[AbraCadaver]

If searched for John and Elton John comes up, the search works, it wouldn't work so well otherwise.

 

If you needed more control and wanted to spend the time more advanced and multiple search queries, fulltext search is a better way.

http://dev.mysql.com/doc/refman/5.7/en/fulltext-search.html

 

Fulltext Boolean can do things matching against,within,excluding,stemming,weighted and so on.

http://dev.mysql.com/doc/refman/5.7/en/fulltext-boolean.html

 

Also, maybe consider 'lastname', 'firstname' and 'middlename' columns.  Easier to concatenate those than try to guess a split on one column.

[.josh]

Very useful command, but if name is Elton John, and I search "John",   Elton John is found as well.

 

I need Elton John is found only if a type: "Elto"  "Elton" "Elton J", etc.

 

Moises

 

but...that's exactly what you said you wanted, yes?  If you want it to match starting at beginning of string, instead of anywhere within string, then remove the first %