mysql search help

[lozza1978]

Hi there,

I have a table called tbl_testsf this table consists of 7 cells, one of the cells is called 'product'

In the product cell we have information like

ptc 960SL
ptc 960XDS
ptc 960FH
etc,

What I would like to do is create a search function for the website, as the mysql info is already in place,

I
The problem I have is if the customer enters 'ptc 960' this pulls up no information.

What I would like to happen is if the customer enters ptc 960 I would like to give the customer a choice of products that are similar to the search criteria

Can anyone help or point me to some documentation that can help me?

Thanks for reading

[liquorvicar]

you probably need LIKE:

SELECT * FROM tbl_testsf WHERE product LIKE 'ptc 960%'

the % is a wildcard symbol. this will therefore match
ptc 960
ptc 960SL
ptc 960XDS
ptc 960FH

you can also use regular expressions in MySQL:
string comparison functions