MySql Wildcards help needed!

[martinal]

Hi All

HELP!! I've searched the forum and all the references to wildcards seem to be for searching for words but I can't find anything for numbers and the % doesn't seem to work.

What I have is a data base of homes which specifies No. of Bedrooms, Max Occupancy and Location. What I want to do is have an advanced search which lets you select a specific number or All. If all are selected then I want to pickup everything? I've tried putting % in a variable and in the MySql query e.g.no_bedrooms = '%$noofbeds%' but none of them work.

Any help would be appreciated.

Cheers
Martin

[streetlife]

Use 'LIKE' instead of '='

no_bedrooms LIKE '%$noofbeds%'

[martinal]

I was just about to post "NEVER MIND I'M STUPID, I'VE SPOTTED MY MISTAKE". I've been looking at the code for a week now and I just couldn't see the wood for the trees!

Thanks for the reply!

[bigduke]

You might want to take a look in the MySQL manual for the REGEXP clause, its a lot more powerful than the LIKE clause, it might be what you're looking for.