catsearch names search

i need query using catsearch to return data that contain search criteria in same order

if my table contains streets information and the table contains id,street_name columns

street names stored in table :

id street_name

1 "abc xyz 111"

2 "111 xyz abc"

3 "xyz 111 abc"

i want return just the first row using catsearch when i have 2 parameters

prefix_name ='abc '

suffix_name ='111'

SELECT *FROM street_informationWHERE catsearch (street_information.street_name,('abc 111'),NULL) > 1

the query above return three rows i just want to return the first row

in other words i need to return any records where suffix_name followed the prefix_name