mySQL version of 'with' clause

The object of my query is to search开发者_运维问答 for a long string in a database. To speed up this process, all records of the longstring table have a hash of that string on the same record. I want