//SQL Query 
  // Select * from test where firstName like '%SearchKey%' or middleName like '%SearchKey%' or lastName like '%SearchKey%'

  DynamicQuery dynamicQuery = DynamicQueryFactoryUtil.forClass(Test.class);
  Criterion criterion = null;
       
  criterion = RestrictionsFactoryUtil.like("firsName", StringPool.PERCENT + searchKeyWord+ StringPool.PERCENT);
  criterion =  RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.like("middleName", StringPool.PERCENT + searchKeyWord+ StringPool.PERCENT));
  criterion = RestrictionsFactoryUtil.or(criterion, RestrictionsFactoryUtil.like("lastName", StringPool.PERCENT + searchKeyWord+ StringPool.PERCENT));
  dynamicQuery.add(criterion);