Search Part Values

[skip]

Hello,

I am trying to search part values from a mysql table

lets say I have field1 with a value of "abc123"

a user enters "ab" how do I match up my user input to the db field?

also can I use str_replace(" ","",FIELDNAME) in my SQL query

thanks all in advance,

Match(Field1) AGAINST ('Val*' IN BOOLEAN MODE)

[Roger_Ramjet]

Usually by using LIKE

$sql = "SELECT * FROM table WHERE col1 LIKE '$input%'";

The % is a wildcard character so that will match anything beginning with whatever is in the $input eg 'ab'.

If you mean what I think you mean then no nothing like that would work in a query. However, that would be perfectly good in the php used to generate a query string, provided that it output a column name that actually exists.