spaces in field

[HDFilmMaker2112]

I'm looking to know if MySQL or PHP would cause problems if a database entry has a space in the beginning of it.

 

Say I have a two entries in a DB.

 

"Test"

and

" Test" *space before T.

 

If one of my users does a search for "Test" would it also return the result of " Test"?

 

[Zane]

It depends on your search script/query.. but typically No it wouldn't turn them both up.  The query would need to use a LIKE clause with wildcards on either end

SELECT * FROM table WHERE field LIKE '%Test%'

[fugix]

the text that the user types in would have to include the whitespace in order for the query to return "Test" without the whitespace. The two strings must be the same unless you use the method that Maq posted

[fenway]

But of course you're not searching an entire DB this way....

[Pikachu2000]

If you're only concerned with leading/trailing spaces, you can use MySQL's TRIM() function on the data in the table, and php's trim() function on the data you're comparing.

 

$data = trim($_POST['data']);
$query = "SELECT field1, field2 FROM table WHERE TRIM(field) = '$data'";