If the number you're searching for is longer than the minimum character limit, then it should just work. For example, doing a fulltext search here, looking for 1234
SQL Query
SELECT POST_ID FROM ubbt_POSTS WHERE MATCH (POST_BODY) against ('1234'in boolean mode)