Let say I have this stored in my database. "ROOSEVELT COLLEGE - SAN MATEO - STU" And i want to retrieve this with words using this as my search "ROOSEVELT COLLEGE SAN MATEO".
something like thisafter this query it should retrieve ROOSEVELT COLLEGE - SAN MATEO - STUPHP Code:
select [column name] from [database] where word="ROOSEVELT COLLEGE SAN MATEO"
Is this possible using regex or like? Thanks.