ignoring hyphen?

[Ark3typ3]

I have a database query that works except that some of the things I want to pull from the database have hyphens in the name. Is it possible to have the query ignore the hyphen but still pull the object with the hyphen in the name? So for example if I have something called "Test - Query", I want to be able to type Test - Query into the input box, hit submit, and have it return the information from the database. Is there a way to achieve this?

[mrbaseball34]

Ark3typ3;10953426 wrote:

I have a database query that works except that some of the things I want to pull from the database have hyphens in the name. Is it possible to have the query ignore the hyphen but still pull the object with the hyphen in the name? So for example if I have something called "Test - Query", I want to be able to type Test - Query into the input box, hit submit, and have it return the information from the database. Is there a way to achieve this?

Look at REGEXP and use it in your WHERE clause.

[bradgrafelman]

I don't even see why regular expressions are needed... you're supply the exact same value, so what's the problem?