My sql table consists of the following columns: house_number (int) and address (text). How can I query the table with a single search string e.g. "13 AnyStreet"? I suspect I should be using the explode function but I'm unsure how to go about it.
Thanks in advance